From: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
---|---|
To: | Magnus Hagander <magnus(at)hagander(dot)net> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: synchronous commit in dump |
Date: | 2010-02-23 23:54:03 |
Message-ID: | 3073cc9b1002231554p72ba9598id3bacc34b68108ea@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, Feb 23, 2010 at 4:40 AM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> 2010/2/23 Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Marko Kreen | 2010-02-24 00:04:04 | Re: Pika buildfarm member failure on pgcrypto/test sha2 |
Previous Message | Jeff Davis | 2010-02-23 23:48:44 | Re: Issues for named/mixed function notation patch |