Re: vacuum, performance, and MVCC

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: vacuum, performance, and MVCC
Дата
Msg-id Pine.OSF.4.61.0606260931380.106743@kosh.hut.fi
обсуждение исходный текст
Ответ на Re: vacuum, performance, and MVCC  (Jan Wieck <JanWieck@Yahoo.com>)
Ответы Re: vacuum, performance, and MVCC  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
On Mon, 26 Jun 2006, 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?

In current code, no. Every heap tuple has corresponding index tuples.

In Bruce's proposal, yes. You would have heap tuples without index tuples 
pointing directly at them. An index scan could only find them by following 
t_ctid chains.

Correct me if I understood you incorrectly, Bruce.

- Heikki


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: vacuum, performance, and MVCC
Следующее
От: Csaba Nagy
Дата:
Сообщение: Re: vacuum row?