Re: An idle thought

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: An idle thought
Дата
Msg-id 1268860188.4053.489.camel@monkey-cat.sm.truviso.com
обсуждение исходный текст
Ответ на An idle thought  (Greg Stark <stark@mit.edu>)
Ответы Re: An idle thought  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: An idle thought  (Simon Riggs <simon@2ndQuadrant.com>)
Re: An idle thought  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
On Tue, 2010-03-16 at 15:29 +0000, Greg Stark wrote:
> I'm picturing storing a bit in the visibility map indicating that *no*
> records are visible in a given page.

I've been thinking for a while that we could store the visibility
information in a structure separate from the heap -- sort of like the
visibility map, but per-tuple and authoritative rather than a per-page
hint.

There are all kinds of challenges there, but it might be worth thinking
about. Visibility information is highly compressible, and requires
constant maintenance (updates, deletes, freezing, etc.). It also might
make it possible to move to 64-bit xids, if we wanted to.

Regards,Jeff Davis



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Order of pg_stat_activity timestamp columns
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Order of pg_stat_activity timestamp columns