Re: visibility maps and heap_prune

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: visibility maps and heap_prune
Дата
Msg-id 200901201649.n0KGnpS18240@momjian.us
обсуждение исходный текст
Ответ на Re: visibility maps and heap_prune  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
Ответы Re: visibility maps and heap_prune  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
Pavan Deolasee wrote:
> On Mon, Dec 8, 2008 at 11:33 AM, Pavan Deolasee <pavan.deolasee@gmail.com>wrote:
> 
> >
> >
> > On Sat, Dec 6, 2008 at 8:08 PM, Heikki Linnakangas <
> > heikki.linnakangas@enterprisedb.com> wrote:
> >
> >>
> >> If you see a straightforward way, please submit a patch!
> >>
> >>
> > Will do that.
> >
> >
> 
> Here is a patch which implements this. The PD_ALL_VISIBLE flag is set if all
> tuples in the page are visible to all transactions and there are no DEAD
> line pointers in the page. The second check is required so that VACUUM takes
> up the page. We could slightly distinguish the two cases (one where the page
> requires vacuuming only because of DEAD line pointers and the other where
> the page-tuples do not require any visibility checks), but I thought its not
> worth the complexity.

Is this patch for 8.4?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: libpq WSACleanup is not needed
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: visibility maps