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 <alvherre(at)alvh(dot)no-ip(dot)org>
> To: Hackers <pgsql-hackers(at)postgresql(dot)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 jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461