Re: [Retrieved]RE: backup and recovery

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Tsirkin Evgeny <tsurkin(at)mail(dot)jct(dot)ac(dot)il>, Naomi Walker <nwalker(at)eldocomp(dot)com>, "Mark M(dot) Huber" <MHuber(at)VMdirect(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [Retrieved]RE: backup and recovery
Date: 2004-03-24 22:54:34
Message-ID: 2347.1080168874@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Naomi Walker 2004-03-24 22:58:16 Re: [Retrieved]RE: backup and recovery
Previous Message Christopher Browne 2004-03-24 21:09:05 Re: [PHP] upgrading to 7.4.2