Re: Vacuum goes worse

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Joshua D. Drake wrote:
> On Tue, 16 Oct 2007 17:03:39 -0700 (PDT)
> Brian Herlihy <btherl@xxxxxxxxxxxx> wrote:
> 
> > Would it make sense to show the FSM stats for individual table
> > vaccums as well?  I'm wondering if the reason they aren't shown is
> > because it wouldn't be useful or isn't practical, or just that it
> > hasn't been done.
> 
> I am not sure how useful it would be as the FSM is global. However what
> would be useful is something like VACUUM SUMMARY, where I could get
> "just" the stats instead of all the other output that comes along with
> VERBOSE.

What would be really useful is to remove all that noise from vacuum and
make it appear on a view.  8.4 material all of this, of course.

-- 
Alvaro Herrera                 http://www.amazon.com/gp/registry/CTMLCN8V17R4
"Estoy de acuerdo contigo en que la verdad absoluta no existe...
El problema es que la mentira sí existe y tu estás mintiendo" (G. Lama)

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux