Re: vacuum, performance, and MVCC

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas DCP SD
Тема Re: vacuum, performance, and MVCC
Дата
Msg-id E1539E0ED7043848906A8FF995BDA579011F007F@m0143.s-mxs.net
обсуждение исходный текст
Ответ на Re: vacuum, performance, and MVCC  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: vacuum, performance, and MVCC  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
> > head of the chain yet.  With an index scan, finding the head is
easy,
> > but for a sequential scan, it seems more difficult, and we don't
have
> > any free space in the tail of the chain to maintain a pointer to the
head.
>
> Thinking some more, there will need to be a bit to uniquely
> identify the head of a CITC.

I don't think so. It would probably be sufficient to impose an order on
the CITC.
e.g. the oldest tuple version in the CITC is the head.
(An idea just in case we can't spare a bit :-)

Andreas


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

Предыдущее
От: PFC
Дата:
Сообщение: Re: vacuum, performance, and MVCC, and compression
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Overhead for stats_command_string et al, take 2