Skip site navigation (1) Skip section navigation (2)

Re: Limited performance on multi core server

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 (view raw or flat)
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

In response to

pgsql-performance by date

Next:From: Greg SmithDate: 2007-12-12 11:48:48
Subject: Re: Limited performance on multi core server
Previous:From: Matthew LunnonDate: 2007-12-12 11:12:42
Subject: Re: Limited performance on multi core server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group