Re: Improving PostgreSQL insert performance

[Jeff Janes <jeff.janes@xxxxxxxxx>]

On Fri, Jun 9, 2017 at 6:04 AM, Frits Jalvingh <jal@xxxxxx> wrote:

I already changed the following config parameters:

work_mem 512MB

synchronous_commit off

Since you are already batching up commits into large chunks, this setting is not very useful, but does risk you losing supposedly-committed data upon a crash.  I would not do it.

 

shared_buffers 512mb

You might try increasing wal_buffers, but the default for this size of shared_buffers is 16MB, which is usually big enough.

 

One thing you are missing is max_wal_size.  The default value of that is probably too small for what you are doing.

But if you are not using COPY, then maybe none of this matters as the bottleneck will be elsewhere.

Cheers,

Jeff