On Tue, Jul 16, 2013 at 3:22 PM, AI Rumman 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 pgsql-general mailing list (pg
Yes, I am sure that I am looking for the same table.
On Tue, Jul 16, 2013 at 4:34 AM, Luca Ferrari wrote:
> On Mon, Jul 15, 2013 at 6:43 PM, Giuseppe Broccolo
> 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
On Mon, Jul 15, 2013 at 6:43 PM, Giuseppe Broccolo
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
(ht
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 ove
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 | 5
