Re: COPY with no WAL, in certain circumstances - Mailing list pgsql-patches

From Euler Taveira de Oliveira
Subject Re: COPY with no WAL, in certain circumstances
Date
Msg-id 20070106215305.GA3281@timbira.com
Whole thread Raw
In response to Re: COPY with no WAL, in certain circumstances  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-patches
Joshua D. Drake wrote:

> > IMHO, this deserves an GUC parameter (use_wal_in_copy?). Because a lot
> > of people use COPY because it's faster than INSERT but expects that it
> > will be in WAL. The default would be use_wal_in_copy = true.
>
> That I don't think makes sense. A copy is an all or nothing option, if a
> copy fails in the middle the whole thing is rolled back.
>
I was worried about PITR, but Simon answers my question: PITR enables so
uses WAL.

--
  Euler Taveira de Oliveira
  http://www.timbira.com/


pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: COPY with no WAL, in certain circumstances
Next
From: Bruce Momjian
Date:
Subject: Re: Allow the identifier length to be increased via