Josh Berkus <josh@xxxxxxxxxxxx> writes: >> It's been pure nonsense in this thread. Please show an example of >> what's not working. > 1) Init a postgresql 8.3 with autovacuum disabled. > 2) Load a backup of a database into that PostgreSQL. > 3) Check pg_stat_user_tables. n_live_tup for all tables will be 0. Really? It works for me. You sure this installation hasn't got stats disabled? Check the beginning of the postmaster log to see if there are any bleats about failing to start the stats collector. > 4) VACUUM ANALYZE the whole database. > 5) n_live_tup will *still* be 0. Whereas reltuples in pg_class will be > reasonable accurate. It's possible you are seeing the effects of the fact that pre-9.0, vacuum and analyze wouldn't create a stats entry for a table that didn't have one already. However, it's entirely not clear why you wouldn't have one already. Also, if you didn't, you wouldn't see any row at all in the pg_stat_user_tables, not a row with n_live_tup = 0. In any case, it's clear that your installation is not operating as intended, and as 8.3 does work for me here. Better look for something interfering with stats collection. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
