Re: Decent VACUUM (was: Buglist)

Поиск
Список
Период
Сортировка
От Manfred Koizar
Тема Re: Decent VACUUM (was: Buglist)
Дата
Msg-id r4eakv03lngq465gsvipehduvcuiae6dh5@4ax.com
обсуждение исходный текст
Ответ на Re: Buglist  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Ответы Re: Decent VACUUM (was: Buglist)
Re: [HACKERS] Decent VACUUM (was: Buglist)
Список pgsql-general
[ still brainstorming ... ]

On Thu, 21 Aug 2003 17:16:50 -0400, Tom Lane <tgl@sss.pgh.pa.us>
wrote:
>> Whenever a backend encounters a dead tuple it inserts a reference to
>> its page into the RSM.
>
>This assumes that backends will visit dead tuples with significant
>probability.  I doubt that assumption is tenable;

Good point.  What about:  Whenever a backend *deletes* a tuple it
inserts a reference to its page into the RSM?  Then an entry in the
RSM doesn't necessarily mean that the referenced page has reclaimable
space, but it would still be valueable information.

Servus
 Manfred

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