Re: How to cope with low disk space

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@myemma.com
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