Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group