Re: COPY with no WAL, in certain circumstances

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, "Bruce Momjian" <bruce(at)momjian(dot)us>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: COPY with no WAL, in certain circumstances
Date: 2007-01-07 08:53:28
Message-ID: 4972.1168160008@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

"Simon Riggs" <simon(at)2ndquadrant(dot)com> writes:
> On Sat, 2007-01-06 at 21:18 -0500, Tom Lane wrote:
>> Uh ... what in the world has an active portal got to do with it?
>> I think you've confused snapshot considerations with crash recovery.

> 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.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2007-01-07 08:57:04 Re: SGML index build fix
Previous Message Simon Riggs 2007-01-07 08:47:21 Re: Parsing ambiguity for ORDER BY ... NULLS FIRST/LAST

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2007-01-07 08:57:04 Re: SGML index build fix
Previous Message Simon Riggs 2007-01-07 08:45:40 Re: COPY with no WAL, in certain circumstances