From: Jim C. Nasby <jim@nasby.net>
To: Jeff Davis <pgsql@j-davis.com>
Cc: Mark Lonsdale <mark.lonsdale@wysdm.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Configuration settings for 32GB RAM server
Date: Thu, 7 Dec 2006 00:03:20 -0600
Message-ID: <20061207060320.GV44124@nasby.net> (raw)
In-Reply-To: <1165254177.25371.33.camel@dogma.v10.wvs>
References: <673ECBB77DA91F47AD4902A5FD73BCE4D5ED15@mail3>
<1165254177.25371.33.camel@dogma.v10.wvs>
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jim@nasby.net, pgsql@j-davis.com, mark.lonsdale@wysdm.com
Subject: Re: Configuration settings for 32GB RAM server
In-Reply-To: <20061207060320.GV44124@nasby.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox