Postgres Pro
Downloads
Home   >   mailing lists

Re: last_vacuum field is not updating - Mailing list pgsql-general

From AI Rumman
Subject Re: last_vacuum field is not updating
Date
Msg-id CAGoODpcJ_W3qqgKXL5_LSkBWV21Ap-wiMRe7rwSPWr7YOo1aLQ@mail.gmail.com
Whole thread Raw
In response to Re: last_vacuum field is not updating  (Luca Ferrari <fluca1978@infinito.it>)
Responses Re: last_vacuum field is not updating  (Luca Ferrari <fluca1978@infinito.it>)
List pgsql-general
Tree view
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 by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: last_vacuum field is not updating
Next
From: David B Harris
Date:
Subject: Using pg_start_backup() and pg_stop_backup()