Albe Laurenz wrote: > Arvind Singh 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. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
