On Mon, Jul 15, 2013 at 6:43 PM, Giuseppe Broccolo
giuseppe.brocc...@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
Yes, I am sure that I am looking for the same table.
On Tue, Jul 16, 2013 at 4:34 AM, Luca Ferrari fluca1...@infinito.it wrote:
On Mon, Jul 15, 2013 at 6:43 PM, Giuseppe Broccolo
giuseppe.brocc...@2ndquadrant.it wrote:
Are you sure you are the table's owner?
It should not be a permission
On Tue, Jul 16, 2013 at 3:22 PM, AI Rumman rumman...@gmail.com wrote:
Yes, I am sure that I am looking for the same table.
What if you analyze the table? Does the column on the stats get updated?
Have you tested such behavior against another (even dummy) table?
Luca
--
Sent via
Why does vacuum table is not updating the field last_vacuum of
pg_stat_user_tables?
select * from pg_stat_user_tables where relname = 'table1';
-[ RECORD 1 ]-+--
relid | 5452445
schemaname| public
relname | table1
seq_scan |
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