Re: last_vacuum field is not updating

Поиск
Список
Период
Сортировка
От AI Rumman
Тема Re: last_vacuum field is not updating
Дата
Msg-id CAGoODpcJ_W3qqgKXL5_LSkBWV21Ap-wiMRe7rwSPWr7YOo1aLQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: last_vacuum field is not updating  (Luca Ferrari <fluca1978@infinito.it>)
Ответы Re: last_vacuum field is not updating  (Luca Ferrari <fluca1978@infinito.it>)
Список pgsql-general
Дерево обсуждения
Yes, I am sure that I am looking for the same table.


On Tue, Jul 16, 2013 at 4:34 AM, Luca Ferrari <fluca1978@infinito.it> wrote:
On Mon, Jul 15, 2013 at 6:43 PM, Giuseppe Broccolo
<giuseppe.broccolo@2ndquadrant.it> wrote:

> Are you sure you are the table's owner?

It should not be a permission problem: it works even after a revoke
all on 9.2.4. Interestingly also the autovacuum is really old. Have
you tried to do a simple vacuum?  From the documentation
(http://www.postgresql.org/docs/current/static/monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE):

Last time at which this table was manually vacuumed (not counting VACUUM FULL)

Are you sure we are looking at the same table?

Luca

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

Предыдущее
От: Luca Ferrari
Дата:
Сообщение: Re: last_vacuum field is not updating
Следующее
От: David B Harris
Дата:
Сообщение: Using pg_start_backup() and pg_stop_backup()