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

From Robert Treat
Subject Re: COPY with no WAL, in certain circumstances
Date
Msg-id 200701061823.47137.xzilla@users.sourceforge.net
Whole thread Raw
In response to Re: COPY with no WAL, in certain circumstances  (Bruce Momjian <bruce@momjian.us>)
List pgsql-patches
On Saturday 06 January 2007 16:40, Bruce Momjian wrote:
> Simon Riggs wrote:
> > > > Or in other words, does this patch mean that all COPY execution that
> > > > is within a transaction will ignore WAL?
> > >
> > > Yes, because it is possible to do in all cases.
> >
> > Very happy to add documentation where Tom suggested.
> >
> > Reason for no documentation was that CREATE INDEX and CREATE TABLE AS
> > SELECT already use this optimisation, but to my knowledge neither was/is
> > documented on those command pages.
>
> I wasn't aware those used the optimization.  Seems they all should be
> documented somewhere.

Might I suggest somewhere under chapter 27, with something akin to what we
have for documenting lock levels and the different operations that use them.
We document the reasons you want to avoid WAL and various operations in the
database that do this automagically.

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

pgsql-patches by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] Allow the identifier length to be increased via a configure option
Next
From: Robert Treat
Date:
Subject: Re: COPY with no WAL, in certain circumstances