Re: Visibility map, partial vacuums

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: Visibility map, partial vacuums
Дата
Msg-id 1227471538.7370.14.camel@jdavis-laptop
обсуждение исходный текст
Ответ на Re: Visibility map, partial vacuums  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Visibility map, partial vacuums  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Sun, 2008-11-23 at 14:05 -0500, Tom Lane wrote:
> A possible problem is that if a relation is filled all in one shot,
> autovacuum would trigger a single vacuum cycle on it and then never have
> a reason to trigger another; leading to the bits never getting set (or
> at least not till an antiwraparound vacuum occurs).  We might want to
> tweak autovac so that an extra vacuum cycle occurs in this case.  But
> I'm not quite sure what a reasonable heuristic would be.
> 

This would only be an issue if using the visibility map for things other
than partial vacuum (e.g. index-only scan), right? If we never do
another VACUUM, we don't need partial vacuum.

Regards,Jeff Davis



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

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: Cool hack with recursive queries
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Logging auto_explain outputs to another log file