From: Tobias Brox <tobias@nordicbet.com>
To: Jim C. Nasby <jim@nasby.net>
Cc: Tobias Brox <tobias@nordicbet.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Swappiness setting on a linux pg server
Date: Thu, 19 Oct 2006 18:35:30 +0200
Message-ID: <20061019163530.GC31916@oppetid.no> (raw)
[Jim C. Nasby - Thu at 10:28:31AM -0500]
> I think it'd be much better to experiment with using much larger
> shared_buffers settings. The conventional wisdom there is from 7.x days
> when you really didn't want a large buffer, but that doesn't really
> apply with the new buffer management we got in 8.0. I know of one site
> that doubled their performance by setting shared_buffers to 50% of
> memory.
I've upped it a bit, but it would require a server restart to get the
new setting into effect. This is relatively "expensive" for us. Does
anyone else share the viewpoint of Nasby, and does anyone have
recommendation for a good value? Our previous value was 200M, and I
don't want to go to the extremes just yet. We have 6G of memory
totally.
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: tobias@nordicbet.com, jim@nasby.net
Subject: Re: Swappiness setting on a linux pg server
In-Reply-To: <20061019163530.GC31916@oppetid.no>
* 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