On Feb 14, 2008, at 10:34 AM, Michiel Holtkamp wrote:
Peter Childs [reformatted] wrote:
> I think you need to know depending on a mix of free disk space and
> free space map usage. If you do a standard Vacuum Verbose it will
tell
> you how full the fsm is. You need to ensure that you have enough
free
> disk space and or a (relativly) full fsm. When the fsm is empty the
> database has to use disk space,
Maybe this is what I'm looking for. Is there any other way to
retrieve information on the fsm usage?
Have a look at the pg_freespacemap contrib package.
Erik Jones
DBA | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
