On Thu, Apr 27, 2006 at 08:12:23PM +0000, Chris Browne wrote: > Having some ability to collect statistics about "we recovered 42 pages > from table foo at 12:45" would seem useful both from an immediate > temporal perspective where it could suggest whether specific tables > were being vacuumed too (seldom|often), and from a more > global/analytic perspective of perhaps suggesting better kinds of > vacuuming policies. (In much the same way that I'd like to have some > way of moving towards an analytically better value for > default_statistics_target than 10...) > > If people are interested, I could provide a copy of the "analyze > VACUUM stats" script...
Yeah, I'm interested. Though just like EXPLAIN output this seems like another case where having the ability to log this information into the database itself would be incredibly valuable for anyone wanting to do later analysis. -- 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 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
