Subject: Re: Limited performance on multi core server
From: Simon Riggs <simon@2ndquadrant.com>
To: mlunnon@rwa-net.co.uk
Cc: pgsql-performance@postgresql.org
In-Reply-To: <4760006C.1070402@commandprompt.com>
References: <475FB50B.8060701@rwa-net.co.uk> <20071212103926.GB5247@uio.no>
	<475FC113.7040103@rwa-net.co.uk> <4760006C.1070402@commandprompt.com>
Content-Type: text/plain
Date: Thu, 13 Dec 2007 16:23:45 +0000
Message-Id: <1197563025.4255.1835.camel@ebony.site>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

On Wed, 2007-12-12 at 07:38 -0800, Joshua D. Drake wrote:
> 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.

Matthew,

Some benchmark comparisons would be really useful though, so please
don't be dissuaded from looking at 8.3. It's planned to be released
after Christmas, so we're probably around 2 business weeks away from
release if you ignore the holiday period.

Everything you've said suggests you've hit the scalability limit of 7.4,
which had a buffer manager that got worse with larger settings, fixed in
8.0. Most of the scalability stuff has been added since then and 8.3
looks to be really fast, but we would still like some more performance
numbers.

-- 
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com