Date: Thu, 7 Dec 2006 00:03:20 -0600
From: "Jim C. Nasby" <jim@nasby.net>
To: Jeff Davis <pgsql@j-davis.com>
Cc: Mark Lonsdale <mark.lonsdale@wysdm.com>, pgsql-performance@postgresql.org
Subject: Re: Configuration settings for 32GB RAM server
Message-ID: <20061207060320.GV44124@nasby.net>
References: <673ECBB77DA91F47AD4902A5FD73BCE4D5ED15@mail3>
	<1165254177.25371.33.camel@dogma.v10.wvs>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1165254177.25371.33.camel@dogma.v10.wvs>
User-Agent: Mutt/1.5.13 (2006-08-11)

On Mon, Dec 04, 2006 at 09:42:57AM -0800, Jeff Davis wrote:
> > fsm_pages = 200,000 ??? Based this on some statistics about the number
> > of pages freed from a vacuum on older server.   Not sure if its fair
> > to calculate this based on vacuum stats of 7.3.4 server?
> > 
> 
> Might as well make it a higher number because you have a lot of RAM
> anyway. It's better than running out of space in the FSM, because to
> increase that setting you need to restart the daemon. Increasing this by
> 1 only uses 6 bytes. That means you could set it to 10 times the number
> you currently have, and it would still be insignificant.

You can also run vacuumdb -av and look at the last few lines to see what
it says you need. Or you can get that info out of
contrib/pg_freespacemap.
-- 
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)