Re: [HACKERS] synchronous commit in dump

2010-02-24 Thread Robert Haas
On Tue, Feb 23, 2010 at 6:54 PM, Jaime Casanova wrote: > On Tue, Feb 23, 2010 at 4:40 AM, Magnus Hagander wrote: >> 2010/2/23 Jaime Casanova : >>> 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 >>>

Re: [HACKERS] synchronous commit in dump

2010-02-23 Thread Jaime Casanova
On Tue, Feb 23, 2010 at 4:40 AM, Magnus Hagander wrote: > 2010/2/23 Jaime Casanova : >> 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 ins

Re: [HACKERS] synchronous commit in dump

2010-02-23 Thread Magnus Hagander
2010/2/23 Jaime Casanova : > 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 p

[HACKERS] synchronous commit in dump

2010-02-22 Thread Jaime Casanova
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 v