Received: from localhost (unknown [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id CD3332E3CDE
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 12 Dec 2007 11:53:35 -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 25853-02-8
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 12 Dec 2007 11:53:32 -0400 (AST)
Received: from lists.commandprompt.com (host-159.commandprompt.net
	[207.173.203.159])
	by postgresql.org (Postfix) with ESMTP id 7B2E72E46FF
	for <pgsql-performance@postgresql.org>;
	Wed, 12 Dec 2007 11:38:15 -0400 (AST)
Received: from [192.168.1.226] (or-69-34-217-90.sta.embarqhsd.net
	[69.34.217.90]) (authenticated bits=0)
	by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id lBCFcCt1000923
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO);
	Wed, 12 Dec 2007 07:38:13 -0800
Message-ID: <4760006C.1070402@commandprompt.com>
Date: Wed, 12 Dec 2007 07:38:20 -0800
From: "Joshua D. Drake" <jd@commandprompt.com>
Organization: Command Prompt, Inc.
User-Agent: Thunderbird 1.5.0.13 (Windows/20070809)
MIME-Version: 1.0
To: mlunnon@rwa-net.co.uk
CC: pgsql-performance@postgresql.org
Subject: Re: Limited performance on multi core server
References: <475FB50B.8060701@rwa-net.co.uk> <20071212103926.GB5247@uio.no>
	<475FC113.7040103@rwa-net.co.uk>
In-Reply-To: <475FC113.7040103@rwa-net.co.uk>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0
	(lists.commandprompt.com [207.173.203.159]);
	Wed, 12 Dec 2007 07:38:13 -0800 (PST)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200712/181
X-Sequence-Number: 27997

Matthew Lunnon wrote:
> Ah I was afraid of that.  Maybe I'll have to come out of the dark ages.

Yes :) but ignore the comment about the 8.3 Beta series. It is Beta for 
a reason, that means testing only, no production.

Sincerely,

Joshua D. Drake

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