Re: [OT] Re: enabling autovacuum

On Mon, 2008-01-28 at 20:57 -0500, Greg Smith wrote:
> On Tue, 29 Jan 2008, Ow Mun Heng wrote:
>
> > Can you let me know what is the sql used to generate such a nice summary
> > of the tables?
>
> Might as well dupe the old text; this went out to the performance list:
>
> Greg Sabino Mullane released a Nagios plug-in for PostgreSQL that you can
> grab at http://bucardo.org/nagios_postgres/ , and while that is itself
> nice the thing I found most remarkable is the bloat check. The majority of
> that code is an impressive bit of SQL that anyone could use even if you
> have no interest in Nagios, which is why I point it out for broader
> attention. Look in check_postgres.pl for the "check_bloat" routine and the
> big statement starting at the aptly labled "This was fun to write"
> section. If you pull that out of there and replace $MINPAGES and
> $MINIPAGES near the end with real values, you can pop that into a
> standalone query and execute it directly.

I'm subscribed to perf list and I _did_ take a look at the tool
previously. However, something happened and I didn't managed to look at
it throughly or something.

I'll take another look at it and thanks for the pointers..