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

Search Discussions

  • Magnus Hagander at Feb 23, 2010 at 9:40 am

    2010/2/23 Jaime Casanova <jcasanov@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.
  • Jaime Casanova at Feb 23, 2010 at 11:54 pm

    On Tue, Feb 23, 2010 at 4:40 AM, Magnus Hagander wrote:
    2010/2/23 Jaime Casanova <jcasanov@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
  • Robert Haas at Feb 24, 2010 at 4:55 pm

    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 <jcasanov@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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedFeb 23, '10 at 4:00a
activeFeb 24, '10 at 4:55p
posts4
users3
websitepostgresql.org...
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase