Re: max_fsm_pages >800k ... ? - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: max_fsm_pages >800k ... ?
Date
Msg-id 200506151118.50625.josh@agliodbs.com
Whole thread Raw
In response to max_fsm_pages >800k ... ?  ("Marc G. Fournier" <scrappy@postgresql.org>)
List pgsql-hackers
Marc,

> Without more information to provide at this time, does the following
> seem "unusual"?
>
> INFO:  free space map: 252 relations, 411494 pages stored; 738640 total
> pages needed DETAIL:  Allocated FSM size: 2000 relations + 400000 pages
> = 2463 kB shared memory.

Looks like you haven't run VACUUM in a few days.   Or like you deleted and 
re-loaded a large table multiple times.

BTW, this is really more of a pgsql-performance question ...

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: Gist Recovery testing
Next
From: "John Hansen"
Date:
Subject: Re: max_fsm_pages >800k ... ?