On Tue, Feb 23, 2010 at 6:54 PM, Jaime Casanova <jcasa...@systemguards.com.ec> wrote: > On Tue, Feb 23, 2010 at 4:40 AM, Magnus Hagander <mag...@hagander.net> wrote: >> 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. > > That isn't necesarily true. Maybe you don't have shell access to the > database server > but just trough pgadmin or something like that... > > in that env the copy of the dumps won't work so you need to make the backup > with > inserts (by need) and still want some performance
I don't see why that would preclude using COPY. But anyway in that case you could still run the restore with -1. ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
