Re: pg_stat: last vacuum and analyze times are not being updated - v8.3.5

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_stat: last vacuum and analyze times are not being updated - v8.3.5
Дата
Msg-id 28922.1269359012@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_stat: last vacuum and analyze times are not being updated - v8.3.5  ("Steve Jones" <Steve.Jones@codeweavers.net>)
Список pgsql-admin
"Steve Jones" <Steve.Jones@codeweavers.net> writes:
> Issue:                                    the last_vacuum column is not
> being updated following a manual vacuum against a table or database.

It works for me in 8.3 ... as long as there already is a stats entry for
the table in question.  You may be running into the pre-9.0 behavior
that the vacuum time update gets thrown away if there is no pre-existing
stats entry.  If you vacuum twice, does the time of the second vacuum
show up?

http://archives.postgresql.org/pgsql-committers/2009-09/msg00062.php

            regards, tom lane

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

Предыдущее
От: "Dai, Tino"
Дата:
Сообщение: Re: Disparity between 8.1.18 and 8.2.14 performance wise
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Disparity between 8.1.18 and 8.2.14 performance wise