Re: [PATCHES] COPY with no WAL, in certain circumstances - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: [PATCHES] COPY with no WAL, in certain circumstances
Date
Msg-id 20070107115902.GB19187@svana.org
Whole thread Raw
In response to Re: [PATCHES] COPY with no WAL, in certain circumstances  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: [PATCHES] COPY with no WAL, in certain circumstances
List pgsql-hackers
On Sun, Jan 07, 2007 at 11:46:29AM +0000, Simon Riggs wrote:
> On Sun, 2007-01-07 at 03:53 -0500, Tom Lane wrote:
> > "Simon Riggs" <simon@2ndquadrant.com> writes:
> > > The patch sets HEAP_XMIN_COMMITTED on all of the rows loaded by COPY as
> > > well.
> >
> > I think you just talked yourself out of getting this patch applied.
>
> Maybe; what would be your explanation? Do you have a failure case you
> know of? Perhaps if one exists, there is another route.

One thing I pondered while looking at this: how do you know the user is
going to commit the transaction after the COPY is complete. Could they
run analyze or vacuum or some other DDL command on the table that would
get confused by the disparity between the hint bits and the xlog.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

pgsql-hackers by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: [PATCHES] COPY with no WAL, in certain circumstances
Next
From: "Simon Riggs"
Date:
Subject: Re: proposal: catch warnings