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)
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? |