Re: 8.1.8 autovacuum missing databases

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 8.1.8 autovacuum missing databases
Дата
Msg-id 21487.1209759497@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 8.1.8 autovacuum missing databases  (Andrew Sullivan <ajs@commandprompt.com>)
Ответы Re: 8.1.8 autovacuum missing databases  (Andrew Sullivan <ajs@commandprompt.com>)
Список pgsql-admin
Andrew Sullivan <ajs@commandprompt.com> writes:
> On Fri, May 02, 2008 at 12:45:07PM -0400, Tom Lane wrote:
>> to have exposed last_autovac_time anywhere in the pgstat views.
>> Obviously we cannot back-patch that, but I think it should be fixed
>> going forward.

> That's already fixed in 8.2 and forward (see
> pg_stat_get_last_autovacuum_time() and the pg_stat%tables views).

Uh, no, what that function returns is the per-table
autovac_vacuum_timestamp.  A grep through the source code shows that
the per-database last_autovac_time is exposed nowhere.

            regards, tom lane

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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: 8.1.8 autovacuum missing databases
Следующее
От: "Balaji Kasthurirangan"
Дата:
Сообщение: Re: could not bind IPv4 socket