Re: [Retrieved]RE: backup and recovery - Mailing list pgsql-admin

From Tom Lane
Subject Re: [Retrieved]RE: backup and recovery
Date
Msg-id 2347.1080168874@sss.pgh.pa.us
Whole thread Raw
In response to Re: [Retrieved]RE: backup and recovery  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [Retrieved]RE: backup and recovery  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Added to TODO:
>     * Have pg_dump use multi-statement transactions for INSERT dumps

> For simple performance reasons, it would be good.  I am not sure about
> allowing errors to continue loading.   Anyone else?

Of course, anyone who actually cares about reload speed shouldn't be
using INSERT-style dumps anyway ... I'm not sure why we should expend
effort on that rather than just telling people to use the COPY mode.

            regards, tom lane

pgsql-admin by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: access multiple PostgreSQL Databases at the same time.
Next
From: Naomi Walker
Date:
Subject: Re: [Retrieved]RE: backup and recovery