Re: vacuum, performance, and MVCC

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: vacuum, performance, and MVCC
Дата
Msg-id 20060626054927.GA6341@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: vacuum, performance, and MVCC  (Jan Wieck <JanWieck@Yahoo.com>)
Ответы Re: vacuum, performance, and MVCC
Re: vacuum, performance, and MVCC
Список pgsql-hackers
Jan Wieck wrote:
> On 6/25/2006 10:12 PM, Bruce Momjian wrote:
> >When you are using the update chaining, you can't mark that index row as
> >dead because it actually points to more than one row on the page, some
> >are non-visible, some are visible.
> 
> Back up the truck ... you mean in the current code base we have heap 
> tuples that are visible in index scans because of heap tuple chaining 
> but without index tuples pointing directly at them?

I don't know where this idea came from, but it's not true.  All heap
tuples, dead or otherwise, have index entries.  Unless the idea is to
extend update chaining to mean something different from the current
meaning.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


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

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: vacuum, performance, and MVCC
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: vacuum, performance, and MVCC