From: | "Claus Guttesen" <kometen(at)gmail(dot)com> |
---|---|
To: | mlunnon(at)rwa-net(dot)co(dot)uk |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Limited performance on multi core server |
Date: | 2007-12-12 11:39:58 |
Message-ID: | b41c75520712120339i4f5ad4fbr78df04647fc09c67@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2007-12-12 11:48:48 | Re: Limited performance on multi core server |
Previous Message | Matthew Lunnon | 2007-12-12 11:12:42 | Re: Limited performance on multi core server |