Re: [HACKERS] synchronous commit in dump
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
Re: [HACKERS] synchronous commit in dump
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
Re: [HACKERS] synchronous commit in dump
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 -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] synchronous commit in dump
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? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers