It would also be very handy to be able to tell how many transactions (or inserts/updates/deletes) have occured since the last vacuum. Presumably autovacuum needs to know this already, but is it exposed?
On Thu, Sep 15, 2005 at 07:46:26AM -0400, Jim Buttafuoco wrote: > while you are at it, can you put in some audit timestamps as to when the > vacuum occurred (full vs not full). > > > ---------- Original Message ----------- > From: Alvaro Herrera <[EMAIL PROTECTED]> > To: Hackers <pgsql-hackers@postgresql.org> > Sent: Wed, 14 Sep 2005 22:14:23 -0400 > Subject: [HACKERS] Per-table freeze limit proposal > > > Hackers, > > > > As you've probably heard too many times already, I'm thinking in > > improving vacuum, so we can keep track of the freeze Xid on a table > > level, rather than database level. Hopefully this will eliminate the > > need for database-wide vacuums. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org