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

From Jeff Ross
Subject Re: Multiple table entries?
Date
Msg-id 4A91ACCA.5030008@wykids.org
Whole thread Raw
In response to Re: Multiple table entries?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Multiple table entries?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> 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
>
>
Well, as the reader that started this all ;-) should I be worried?  I
don't see any obvious problem with the way 8.4.0 is working.  Nearly
every web page on my server is stored in postgres, and we're still
churning out pages, no problem.

Should I do a pg_dump and reinstall?  Roll back to 8.3.7?  Or just
relax, don't worry and have a sparkling adult beverage?

Thanks,

Jeff (proceeding with relaxing, not worrying, and so on)



pgsql-general by date:

Previous
From: Sergey Samokhin
Date:
Subject: What approach should I use instead of creating tables on the fly?
Next
From: Andrew Cooper
Date:
Subject: Re: Figuring out relationships between tables.