Re: autovacuum not prioritising for-wraparound tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: autovacuum not prioritising for-wraparound tables
Дата
Msg-id 25728.1359760101@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: autovacuum not prioritising for-wraparound tables  (Christopher Browne <cbbrowne@gmail.com>)
Список pgsql-hackers
Christopher Browne <cbbrowne@gmail.com> writes:
> I picked values that I knew could be easily grabbed, and we don't
> have an immediate tuples-per-page estimate on pg_class.

Er, what?  reltuples/relpages is exactly that estimate --- in fact,
it's only because of historical accident that we don't store a single
float field with that ratio, rather than two fields.  Both the creation
and the usage of those numbers work explicitly with the ratio.
        regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: json api WIP patch
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: autovacuum not prioritising for-wraparound tables