Re: new autovacuum criterion for visible pages

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: new autovacuum criterion for visible pages
Дата
Msg-id 31535.1470960074@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: new autovacuum criterion for visible pages  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: new autovacuum criterion for visible pages  (Masahiko Sawada <sawada.mshk@gmail.com>)
Re: new autovacuum criterion for visible pages  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
Дерево обсуждения 
Michael Paquier <michael.paquier@gmail.com> writes:
> In short, autovacuum will need to scan by itself the VM of each
> relation and decide based on that.

That seems like a worthwhile approach to pursue.  The VM is supposed to be
small, and if you're worried it isn't, you could sample a few pages of it.
I do not think any of the ideas proposed so far for tracking the
visibility percentage on-the-fly are very tenable.
        regards, tom lane

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

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: [Patch] New psql prompt substitution %r (m = master, r = replica)
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: [Patch] New psql prompt substitution %r (m = master, r = replica)