[check_postgres] RFC: New Actions

[Greg Sabino Mullane]

On Tue, Jan 18, 2011 at 10:10:45AM +1300, Mark Kirkwood wrote:
> On 18/01/11 10:05, Greg Sabino Mullane wrote:
> >
> > I'm been working on the bloat check recently, so some future verision
> > will have a much better algorithm which will also reduce false
> > positives. /aside
> >
> 
> For 8.4 onwards, you could use pg_freespacemap and get exact bloat 
> figures (provided autovacuum is running that is).

We're already using that: see the fsm_pages and fsm_relations actions.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/check_postgres/attachments/20110120/88243929/attachment.bin