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

Re: Limited performance on multi core server

From: Simon Riggs <simon(at)2ndquadrant(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-13 16:23:45
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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.


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

  Simon Riggs

In response to


pgsql-performance by date

Next:From: Kevin GrittnerDate: 2007-12-13 16:26:58
Subject: Re: Heavy write activity on first vacuum of freshTOAST data
Previous:From: Simon RiggsDate: 2007-12-13 16:11:23
Subject: Re: Heavy write activity on first vacuum of fresh TOASTdata

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