Re: Multiple table entries?

From: Jeff Ross <jross(at)wykids(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Greg Stark <gsstark(at)mit(dot)edu>, Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Multiple table entries?
Date: 2009-08-23 20:55:38
Message-ID: 4A91ACCA.5030008@wykids.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:
> Greg Stark <gsstark(at)mit(dot)edu> writes:
>
>> On Sun, Aug 23, 2009 at 7:34 PM, Tom Lane<tgl(at)sss(dot)pgh(dot)pa(dot)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)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Cooper 2009-08-23 21:10:38 Re: Figuring out relationships between tables.
Previous Message Sergey Samokhin 2009-08-23 20:31:55 What approach should I use instead of creating tables on the fly?