| From: | AI Rumman <rummandba(at)gmail(dot)com> |
|---|---|
| To: | Luca Ferrari <fluca1978(at)infinito(dot)it> |
| Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: last_vacuum field is not updating |
| Date: | 2013-07-16 13:22:05 |
| Message-ID: | CAGoODpcJ_W3qqgKXL5_LSkBWV21Ap-wiMRe7rwSPWr7YOo1aLQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)infinito(dot)it> wrote:
> On Mon, Jul 15, 2013 at 6:43 PM, Giuseppe Broccolo
> <giuseppe(dot)broccolo(at)2ndquadrant(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David B Harris | 2013-07-16 14:10:28 | Using pg_start_backup() and pg_stop_backup() |
| Previous Message | Luca Ferrari | 2013-07-16 08:34:31 | Re: last_vacuum field is not updating |