Re: Multiple table entries? - Mailing list pgsql-general

From Tom Lane
Subject Re: Multiple table entries?
Date
Msg-id 3282.1251057068@sss.pgh.pa.us
Whole thread Raw
In response to Re: Multiple table entries?  (Greg Stark <gsstark@mit.edu>)
Responses Re: Multiple table entries?  (Jeff Ross <jross@wykids.org>)
List pgsql-general
Greg Stark <gsstark@mit.edu> writes:
> On Sun, Aug 23, 2009 at 7:34 PM, Tom Lane<tgl@sss.pgh.pa.us> wrote:
>> Urgh.  I bet that's where the problem is then.  Some path is failing
>> to clear that bit, or maybe there's a race condition that allows it
>> to become set incorrectly (ie right after somebody else adds a tuple).

> Well it only gets set in vacuum when we have the vacuum cleanout lock
> so I can't see it getting set incorrectly unless there's a simple
> logic error in vacuum. I just scanned it and it looks right to me.

heap_update is broken.  Details left as an exercise for the reader
(hint: Heikki has blatantly ignored the WAL-logging rules in transam/README)

            regards, tom lane

pgsql-general by date:

Previous
From: Juan Backson
Date:
Subject: libpq performance
Next
From: Jeff Ross
Date:
Subject: Re: Multiple table entries?