Re: 8.1.8 autovacuum missing databases

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 8.1.8 autovacuum missing databases
Дата
Msg-id 7451.1209746707@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 8.1.8 autovacuum missing databases  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: 8.1.8 autovacuum missing databases
Список pgsql-admin
I wrote:
> Perhaps it is worth adding a defense to autovac to not believe last
> autovac times that are in the future, since the system clock is not
> under our control and could go backwards.  Other than that I don't
> think there's any bug here.

Oh, the other thing that comes to mind is that it's a bad move not
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.  This whole thing might've been much less of a mystery
if that state had been visible.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 8.1.8 autovacuum missing databases
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: 8.1.8 autovacuum missing databases