From: Claus Guttesen <kometen@gmail.com>
To: Matthew Lunnon <mlunnon@rwa-net.co.uk>
To: pgsql-performance@postgresql.org
Subject: Re: Limited performance on multi core server
Date: Wed, 12 Dec 2007 11:48:31 +0100
Message-ID: <b41c75520712120248i269f250bvaedcd0ff2e8ed7c4@mail.gmail.com> (raw)
In-Reply-To: <20071212103926.GB5247@uio.no>
References: <475FB50B.8060701@rwa-net.co.uk>
<20071212103926.GB5247@uio.no>
> > Does anyone have any ideas what my bottle neck might be and what I can do
> > about it?
>
> Your bottleneck is that you are using a very old version of PostgreSQL. Try
> 8.2 or (if you can) the 8.3 beta series -- it scales a _lot_ better in this
> kind of situation.
You won't know until you've seen what queries are performed. Changing
db-parameters is a short-term solution, upgrading to a newer version
does require some planning.
--
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: <b41c75520712120248i269f250bvaedcd0ff2e8ed7c4@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