Re: patch review, please: Autovacuum/Vacuum times via stats.

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: patch review, please: Autovacuum/Vacuum times via stats.
Дата
Msg-id 20060503135457.GB27354@svana.org
обсуждение исходный текст
Ответ на Re: patch review, please: Autovacuum/Vacuum times via stats.  ("Jim C. Nasby" <jnasby@pervasive.com>)
Ответы Re: patch review, please: Autovacuum/Vacuum times via stats.
Re: patch review, please: Autovacuum/Vacuum times via stats.
Список pgsql-hackers
On Tue, May 02, 2006 at 05:49:33PM -0500, Jim C. Nasby wrote:
> Back in the discussion of this someone had mentioned capturing all the
> info that you'd get from a vacuum verbose; dead tuples, etc. What do
> people think about that? In particular I think it'd be handy to know how
> many pages vacuum wanted in the FSM vs. how many it got; this would make
> it much easier for people to ensure that the FSM is large enough. Using
> the functions that let you query the FSM won't work because they can't
> tell you if there are pages that should have been in the FSM but didn't
> make it in.

That's a good idea too, but in that case I'd vote for putting it into a
seperate table/view and not with the stats relating to number of seq
scans for example.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

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

Предыдущее
От: "Jim Buttafuoco"
Дата:
Сообщение: drop database command blocking other connections
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Is a SERIAL column a "black box", or not?