Alvaro Herrera wrote:
>>> Are there any particular settings or methods available to improve
Just
>>> insert_table operations
>>
>> The obvious ones:
>> - Wrap several of them in a transaction.
>> - Increase checkpoint_segments.
>> - Set fsync=off and hope you don't crash.
>
> I think it would work to set asynchronous_commit=off for the
> transactions that insert moves. That way, the fsync flushes happen in
> the background and are batched. Raising wal_buffers is probably a
good
> idea, and keep an eye on how the walwriter is doing.
I guess you mean synchronous_commit=off :^)
Yes, I forgot that one.
Yours,
Laurenz Albe