Re: Postgresql backend to perform vacuum automatically

> 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