Re: [Proposal] More Vacuum Statistics

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: [Proposal] More Vacuum Statistics
Дата
Msg-id CAMkU=1ySQOwXEbe4dWjZ1iEEDuotq_GscQngtVFQb0UjMaqTfw@mail.gmail.com
обсуждение исходный текст
Ответ на [Proposal] More Vacuum Statistics  (Naoya Anzai <nao-anzai@xc.jp.nec.com>)
Список pgsql-hackers
On Thu, May 28, 2015 at 4:08 AM, Naoya Anzai <nao-anzai@xc.jp.nec.com> wrote:

2. Page visibility rate of each table
There is no way to know how many page-bits are them of each tables stored
in their visibility maps. If we can show this information, then we will be
able to guess vacuum overhead for the table. For example, if this table is a
very big table but page visibility rate is high, then we can advise pg-users
that vacuum for this table will execute faster than they think by low I/O overhead.
Furthermore, this information can also be used in order to inform pg-users
about "real" index-only-scan usability.

Isn't this already pg_class.relallvisible?

 
Cheers,

Jeff

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Re: [GENERAL] 9.4.1 -> 9.4.2 problem: could not access status of transaction 1
Следующее
От: Tom Lane
Дата:
Сообщение: Re: fsync-pgdata-on-recovery tries to write to more files than previously