Postgres Pro
Downloads
Home   >   mailing lists

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

From Giuseppe Broccolo
Subject Re: last_vacuum field is not updating
Date
Msg-id 51E4269C.1020308@2ndquadrant.it
Whole thread Raw
In response to last_vacuum field is not updating  (AI Rumman <rummandba@gmail.com>)
Responses Re: last_vacuum field is not updating  (Luca Ferrari <fluca1978@infinito.it>)
List pgsql-general
Tree view 
Hi Al,

Il 15/07/2013 16:58, AI Rumman ha scritto:
> Why does vacuum table is not updating the field last_vacuum of
> pg_stat_user_tables?
>
To vacuum a table, one must ordinarily be the table's owner. However,
database owners are allowed to vacuum all tables in their databases.
VACUUM will skip over any tables that the calling user does not have
permission to vacuum.

Are you sure you are the table's owner?

Regards,

Giuseppe.

--
Giuseppe Broccolo - 2ndQuadrant Italy
PostgreSQL Training, Services and Support
giuseppe.broccolo@2ndQuadrant.it | www.2ndQuadrant.it

pgsql-general by date:

Previous
From: Granthana Biswas
Date:
Subject: Re: Transaction control in shards through PLPROXY
Next
From: Bradley McCune
Date:
Subject: Re: V8.4 TOAST table problem