Re: pg_class reltuples/relpages not updated by autovacuum/vacuum

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