Re: [PATCH] Addition of some trivial auto vacuum logging

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: [PATCH] Addition of some trivial auto vacuum logging
Дата
Msg-id 20110928003629.GX12765@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: [PATCH] Addition of some trivial auto vacuum logging  (Royce Ausburn <royce.ml@inomial.com>)
Список pgsql-hackers
* Royce Ausburn (royce.ml@inomial.com) wrote:
> Just a question:  is the utility great enough to warrant me working further on this?  I have no real desire to
implementthis particular feature -- I simply saw an opportunity to cut my teeth on something easy.  I'd be happy to
findsomething on the TODO list instead if this feature isn't really worthwhile.
 

Seeing as how it's already got one committer willing to consider it (and
that one tends to go the other direction on new features..), I'd
definitely say it's worthwhile.  That doesn't mean it's guaranteed to
get in, but I'd put the probability above 75% given that feedback.
That's pretty good overall. :)

> Tom's suggestion looks like it's less trivial that I can do just yet, but I'll take a look and ask for help if I need
it.

Don't let the notion of fiddling with the catalogs (system tables)
discourage you..  It's really not all *that* bad.  What you will need to
figure out (and which I don't recall offhand..) is if you can just
update those catalogs directly from VACUUM or if you need to go through
the statistics collecter (which involves a bit of UDP communication, but
hopefully we've abstracted that out enough that you won't have to deal
with it directly really..).

Looking at an existing example case where VACUUM is doing something that
updates the stat tables (such as under the 'ANALYZE' option) will help
out a lot, I'm sure.
Thanks,
    Stephen

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

Предыдущее
От: Royce Ausburn
Дата:
Сообщение: Re: [PATCH] Addition of some trivial auto vacuum logging
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [PATCH] Addition of some trivial auto vacuum logging