Re: Multiple table entries?

Поиск
Список
Период
Сортировка
От Jeff Ross
Тема Re: Multiple table entries?
Дата
Msg-id 4A91ACCA.5030008@wykids.org
обсуждение исходный текст
Ответ на Re: Multiple table entries?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Multiple table entries?
Список 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 по дате отправления:

Предыдущее
От: Sergey Samokhin
Дата:
Сообщение: What approach should I use instead of creating tables on the fly?
Следующее
От: Andrew Cooper
Дата:
Сообщение: Re: Figuring out relationships between tables.