Florian Helmberger <fh@xxxxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
