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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
