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

Re: Limited performance on multi core server

From: Heikki Linnakangas <heikki(at)enterprisedb(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-14 11:11:58
Message-ID: 476264FE.8050101@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

pgsql-performance by date

Next:From: Roberts, JonDate: 2007-12-14 15:01:09
Subject: viewing source code
Previous:From: Heikki LinnakangasDate: 2007-12-14 11:03:56
Subject: Re: Need help on parameters and their values to tune the postgresql database

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