[check_postgres] getting the FREE size after vaccum
Greg Sabino Mullane
greg at endpoint.com
Wed Sep 2 15:52:58 UTC 2009
> Is there an easy way to know what is the size that is free in a
> database or any table after performing vaccum analyze ?
>
> Since I have many updates and lots of "dead" rows - I wanted to know
> if I can come up with a number saying how much is free for writing
> after vaccum analyze.
>
> I know the way to get the dead-tuples, deleted and live tuples stats
> but can I use these stats for calculating free size ?
Exactly what number are you looking for? The amount of space available
is going to be the free space on your hard disk.
--
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 226 bytes
Desc: OpenPGP digital signature
Url : https://mail.endcrypt.com/pipermail/check_postgres/attachments/20090902/48961192/attachment.bin
More information about the Check_postgres
mailing list