Re: Vacuum questions... - Mailing list pgsql-hackers

From Jim C. Nasby
Subject Re: Vacuum questions...
Date
Msg-id 20050926180857.GN30974@pervasive.com
Whole thread Raw
In response to Re: Vacuum questions...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sun, Sep 25, 2005 at 11:50:14AM -0400, Tom Lane wrote:
> Hannu Krosing <hannu@skype.net> writes:
> > Perhaps VACUUM could send some statistics after each N pages and this
> > would then be available through something similar to pg_statistics
> > table.
> 
> Why not just have it send some text to be displayed in the "current
> command" field of pg_stat_activity?  The infrastructure is all there
> already for that.

If someone wanted to write a nice interface showing the status of a
vacuum it would be easier if they didn't have to parse a text field...
but *anything* would be a vast improvement over what we have now.

newbie TODO?
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: \d on database with a lot of tables is slow
Next
From: Andreas Pflug
Date:
Subject: Re: On Logging