Re: last_vacuum field is not updating

From: Giuseppe Broccolo <giuseppe(dot)broccolo(at)2ndquadrant(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: last_vacuum field is not updating
Date: 2013-07-15 16:43:08
Message-ID: 51E4269C.1020308@2ndquadrant.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)broccolo(at)2ndQuadrant(dot)it | www.2ndQuadrant.it

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bradley McCune 2013-07-15 17:07:18 Re: V8.4 TOAST table problem
Previous Message AI Rumman 2013-07-15 14:58:34 last_vacuum field is not updating