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
