From: Claus Guttesen <kometen@gmail.com>
To: mlunnon@rwa-net.co.uk
Cc: pgsql-performance@postgresql.org
Subject: Re: Limited performance on multi core server
Date: Wed, 12 Dec 2007 12:39:58 +0100
Message-ID: <b41c75520712120339i4f5ad4fbr78df04647fc09c67@mail.gmail.com> (raw)
In-Reply-To: <475FC22A.2070505@rwa-net.co.uk>
References: <475FB50B.8060701@rwa-net.co.uk>
<b41c75520712120245k40994522g562954e02899a8d2@mail.gmail.com>
<475FC22A.2070505@rwa-net.co.uk>
> Thanks for the information Claus, Why would reducing the effective cache
> size help the processor usage? It seems that there is plenty of resources
> on the box although I can see that 10MB of sort space could mount up if we
> had 500 connections but at the moment we do not have anything like that
> number.
There is a discussion at
http://archives.postgresql.org/pgsql-performance/2005-06/msg00477.php
which can give a clearer picture. But in general rasing values can be
counterproductive.
If you know that you won't need more than 250 connections that would
be a reasonable value. You may wan't to read
http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html as
well. This has some rules of thumb on the settings for 7.4.x.
--
regards
Claus
When lenity and cruelty play for a kingdom,
the gentlest gamester is the soonest winner.
Shakespeare
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: kometen@gmail.com, mlunnon@rwa-net.co.uk
Subject: Re: Limited performance on multi core server
In-Reply-To: <b41c75520712120339i4f5ad4fbr78df04647fc09c67@mail.gmail.com>
* 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