Re: pg_class reltuples/relpages not updated by autovacuum/vacuum - Mailing list pgsql-admin

Florian Helmberger <fh@25th-floor.com> writes:
> I'm running a production database with PostgreSQL 9.0.3 (64-bit) on
> Debian 5.0.4 and have an issue with a TOAST table and far to frequent
> autovacuum runs.

> I think I've pinned the problem down to the values pg_class holds for
> the affected TOAST table:

> relpages  | 433596
> reltuples | 1868538

> These values are significantly too low. Interestingly, the autovacuum
> logout reports the correct values:

>     pages: 0 removed, 34788136 remain
>     tuples: 932487 removed, 69599038 remain

> but these aren't stored in pg_class after each run.

That's exceedingly weird.  Do the pg_stat_all_tables columns update
after autovacuums on that table?

            regards, tom lane