Am Mittwoch, 4. September 2002 05:44 schrieb Matthew T. OConnor: > I have been doing some poking around with this item, and I was planning on > using the stats collector to do "intelligent" auto-vacuuming. I was > planning on adding some new columns that account for activity that has > taken place since the last vacuum. The current stats collector shows > n_tup_ins, n_tup_upd and n_tup_del for any given rel, but those numbers > have nothing to do with what has happened since the last vacuum, hence > nothing to do with current status or need for vacuum.
This should be no real problem, extending the table pg_stat_all_tables with 3 fields "av_n_tup_ins", "av_n_tup_upd", "av_n_tup_del" should do it IMO. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]