Re: Limited performance on multi core server - Mailing list pgsql-performance

From Simon Riggs
Subject Re: Limited performance on multi core server
Date
Msg-id 1197563025.4255.1835.camel@ebony.site
Whole thread Raw
In response to Re: Limited performance on multi core server  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Limited performance on multi core server
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Heavy write activity on first vacuum of fresh TOAST data
Next
From: "Kevin Grittner"
Date:
Subject: Re: Heavy write activity on first vacuum of fresh TOAST data