Re: fsm allocation - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: fsm allocation
Date
Msg-id 20051118211159.GD29354@phlogiston.dyndns.org
Whole thread Raw
In response to fsm allocation  (Colton A Smith <smith@cs.utk.edu>)
Responses Re: fsm allocation
List pgsql-admin
On Thu, Nov 17, 2005 at 08:20:12AM -0500, Colton A Smith wrote:
>   By the way, what exactly is the 'free map space' anyway?  And why does
> it need so much space?

There's a useful description in the docs, section 17.4.2 (for 8.1).
I'd look at that.

Your usage might not be stable right now because your FSM was wrong
to begin with.  My bet is that you need to do either a VACUUM FULL or
a dump and reload before twiddling these settings much more.  You
also maybe want either autovacuum, or to increase the frequency of
your vacuums.  Given the database size you discussed, I can't believe
you really need that much space.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.
                --Brad Holland

pgsql-admin by date:

Previous
From: Joel Stevenson
Date:
Subject: Re: Suggested HW for postgres ?
Next
From: Tom Lane
Date:
Subject: Re: fsm allocation