> Are there tables that track information that would be useful for guiding
> vacuum? Could I write a program which queries some statistical tables and and
> knows which tables need to be vacuumed?
>
> If the info is around, I could whip up something pretty easily, I think.
Sure, Jan's new statistics tables in 7.2 had just that info.test=> \d pg_stat_user_tables View
"pg_stat_user_tables" Column | Type | Modifiers ---------------+---------+----------- relid | oid
| relname | name | seq_scan | bigint | seq_tup_read | bigint | idx_scan | numeric |
idx_tup_fetch| numeric | n_tup_ins | bigint | n_tup_upd | bigint | n_tup_del | bigint |
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026
