Received: from localhost (unknown [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 6F0802E0149
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 12 Dec 2007 07:08:08 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 05761-05 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 12 Dec 2007 07:08:04 -0400 (AST)
Received: from mail-relay.rwa-net.co.uk (mail-relay.rwa-net.co.uk
	[62.189.139.18])
	by postgresql.org (Postfix) with ESMTP id AC33B2E0153
	for <pgsql-performance@postgresql.org>;
	Wed, 12 Dec 2007 07:08:04 -0400 (AST)
Received: from saturn.rwa-net.co.uk (saturn.rwa-net.co.uk [62.189.139.33])
	by mail-relay.rwa-net.co.uk (Postfix) with ESMTP id 043F87D61E1
	for <pgsql-performance@postgresql.org>;
	Wed, 12 Dec 2007 10:48:54 +0000 (GMT)
Received: from [127.0.0.1] by saturn.rwa-net.co.uk (GMS
	14.01.3539/NT4698.00.83343e8d) with ESMTP id rxnfgaaa for
	pgsql-performance@postgresql.org; Wed, 12 Dec 2007 11:08:03 +0000
Message-ID: <475FC113.7040103@rwa-net.co.uk>
Date: Wed, 12 Dec 2007 11:08:03 +0000
From: Matthew Lunnon <mlunnon@rwa-net.co.uk>
Reply-To: mlunnon@rwa-net.co.uk
Organization: RWA
User-Agent: Thunderbird 1.5.0.13 (Windows/20070809)
MIME-Version: 1.0
To: Matthew Lunnon <mlunnon@rwa-net.co.uk>, pgsql-performance@postgresql.org
Subject: Re: Limited performance on multi core server
References: <475FB50B.8060701@rwa-net.co.uk> <20071212103926.GB5247@uio.no>
In-Reply-To: <20071212103926.GB5247@uio.no>
Content-Type: multipart/alternative;
	boundary="------------010405020509000004080402"
X-AuthenticatedSender: mlunnon@rwa-net.co.uk
X-Info: UNKNOWN-USER
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200712/167
X-Sequence-Number: 27983

This is a multi-part message in MIME format.
--------------010405020509000004080402
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Ah I was afraid of that.  Maybe I'll have to come out of the dark ages.

Matthew

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 */
>   

-- 
Matthew Lunnon
Technical Consultant
RWA Ltd.

 mlunnon@rwa-net.co.uk
 Tel: +44 (0)29 2081 5056
 www.rwa-net.co.uk
--


--------------010405020509000004080402
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Ah I was afraid of that.  Maybe I'll have to come out of the dark ages.<br>
<br>
Matthew<br>
<br>
Steinar H. Gunderson wrote:
<blockquote cite="mid20071212103926.GB5247@uio.no" type="cite">
  <pre wrap="">On Wed, Dec 12, 2007 at 10:16:43AM +0000, Matthew Lunnon wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">Does anyone have any ideas what my bottle neck might be and what I can do 
about it?
    </pre>
  </blockquote>
  <pre wrap=""><!---->
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 */
  </pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">-- 
Matthew Lunnon
Technical Consultant
RWA Ltd.

 <a class="moz-txt-link-abbreviated" href="mailto:mlunnon@rwa-net.co.uk">mlunnon@rwa-net.co.uk</a>
 Tel: +44 (0)29 2081 5056
 <a class="moz-txt-link-abbreviated" href="http://www.rwa-net.co.uk">www.rwa-net.co.uk</a>
--</pre>
</body>
</html>

--------------010405020509000004080402--