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
|
Список | 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 по дате отправления: