From: Jeff Davis <pgsql@j-davis.com>
To: Mark Lonsdale <mark.lonsdale@wysdm.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Configuration settings for 32GB RAM server
Date: Mon, 04 Dec 2006 09:42:57 -0800
Message-ID: <1165254177.25371.33.camel@dogma.v10.wvs> (raw)
In-Reply-To: <673ECBB77DA91F47AD4902A5FD73BCE4D5ED15@mail3>
References: <673ECBB77DA91F47AD4902A5FD73BCE4D5ED15@mail3>
On Mon, 2006-12-04 at 12:10 -0500, Mark Lonsdale wrote:
> - 4 physical CPUs (hyperthreaded to 8)
>
> - 32 GB RAM
>
> - x86_64 architecture
>
> - RedHat AS 4
>
> - postgres 8.1.5
>
>
>
> Ive been taking a look at the various postgres tuning parameters, and
> have come up with the following settings.
>
>
>
> shared_buffers – 50,000 - >From what Id read, increasing this
> number higher than this wont have any advantages ?
>
Where did you read that? You should do some tests. Generally 25% of
physical memory on a dedicated box is a good point of reference (on 8.1,
anyway). I've heard as high as 50% can give you a benefit, but I haven't
seen that myself.
> 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.
Regards,
Jeff Davis
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: pgsql@j-davis.com, mark.lonsdale@wysdm.com
Subject: Re: Configuration settings for 32GB RAM server
In-Reply-To: <1165254177.25371.33.camel@dogma.v10.wvs>
* 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