Search Postgresql Archives

Re: last_vacuum field is not updating

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxx | www.2ndQuadrant.it



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux