From: Heikki Linnakangas <heikki@enterprisedb.com>
To: mlunnon@rwa-net.co.uk
Cc: pgsql-performance@postgresql.org
Subject: Re: Limited performance on multi core server
Date: Fri, 14 Dec 2007 11:11:58 +0000
Message-ID: <476264FE.8050101@enterprisedb.com> (raw)
In-Reply-To: <475FC113.7040103@rwa-net.co.uk>
References: <475FB50B.8060701@rwa-net.co.uk>
<20071212103926.GB5247@uio.no>
<475FC113.7040103@rwa-net.co.uk>
Matthew Lunnon wrote:
> Ah I was afraid of that. Maybe I'll have to come out of the dark ages.
At the very least, upgrade to latest 7.4 minor version. It probably
won't help with you're performance, but 7.4.3 is very old. There's been
a *lot* of bug fixes between 7.4.3 and 7.4.18, including fixes for
security vulnerabilities and data corruption bugs.
> Steinar H. Gunderson wrote:
>> On Wed, Dec 12, 2007 at 10:16:43AM +0000, Matthew Lunnon wrote:
>>
>>> 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.
>>
>> /* Steinar */
>>
>
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
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: heikki@enterprisedb.com, mlunnon@rwa-net.co.uk
Subject: Re: Limited performance on multi core server
In-Reply-To: <476264FE.8050101@enterprisedb.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