Re: [Proposal] More Vacuum Statistics

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [Proposal] More Vacuum Statistics
Дата
Msg-id 20150530024125.GG6535@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: [Proposal] More Vacuum Statistics  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Ответы Re: [Proposal] More Vacuum Statistics  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: [Proposal] More Vacuum Statistics  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [Proposal] More Vacuum Statistics  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
On 2015-05-29 21:30:57 -0500, Jim Nasby wrote:
> It occurs to me that there's no good reason for vacuum-derived stats to be
> in the stats file; it's not like users run vacuum anywhere near as often as
> other commands. It's stats could be kept in pg_class; we're already keeping
> things like relallvisible there.

While it might be viable to store them somewhere but the stat files, I
don't think pg_class is a good place. Its size is not any less critical
than the stats files. I.e. reading it sits in several rather hot paths,
and we keep tuples from it in memory in a lot of places.

Greetings,

Andres



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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: [Proposal] More Vacuum Statistics
Следующее
От: Peter Eisentraut
Дата:
Сообщение: cannot set view triggers to replica