Re: Multiple table entries?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Multiple table entries?
Дата
Msg-id 3282.1251057068@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Multiple table entries?  (Greg Stark <gsstark@mit.edu>)
Ответы Re: Multiple table entries?
Список 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 по дате отправления:

Предыдущее
От: Juan Backson
Дата:
Сообщение: libpq performance
Следующее
От: Jeff Ross
Дата:
Сообщение: Re: Multiple table entries?