Re: Much Ado About COUNT(*)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Much Ado About COUNT(*)
Дата
Msg-id 5213.1105592092@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Much Ado About COUNT(*)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Much Ado About COUNT(*)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> My basic idea was to keep a status bit on each index entry telling it if
> a previous backend looked at the heap and determined it was valid.

Even if you could track the tuple's committed-good status reliably, that
isn't enough under MVCC.  The tuple might be committed good, and seen
that way by some other backend that set the bit, and yet it's not supposed
to be visible to your older transaction.  Or the reverse at tuple
deletion.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Much Ado About COUNT(*)
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Much Ado About COUNT(*)