2010/2/23 Jaime Casanova <jcasa...@systemguards.com.ec>: > Hi, > > it's safe to set synchrounous_commit to off in a pg_dump generated > script? if yes, would this help to the performance of restore a > database?
It might help if you're dumping as individual inserts and not COPY, but if you're doing that you're not asking for performance in the first place. I don't really see how it would help in any other cases - sync_commit=off helps when you have many small transactions, which really is the opposite of pg_dump/pg_restore. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers