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

Re: scalablility problem

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Xiaoning Ding <dingxn(at)cse(dot)ohio-state(dot)edu>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: scalablility problem
Date: 2007-03-30 21:44:39
Message-ID: 1175291079.25022.114.camel@state.g2switchworks.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Fri, 2007-03-30 at 16:38, Xiaoning Ding wrote:
> Thanks guys,
> 
> I update PG to 8.2.3. The results are much better now.
> 1 process :    0.94 second
> 2 processes: 1.32 seconds
> 4 processes: 2.03 seconds
> 8 processes: 2.54 seconds
> 
> Do you think they are good enough?
> BTW where can I found some info on what 8.2.3 did to improve
> scalability compared with pre 8.1 versions?

Very nice, eh?  

I'd say look through -hackers and -perform to see some of it, but as
usual, the source code is the reference.  You'd be surprised how well
commented it is.

In response to

pgsql-performance by date

Next:From: Josh BerkusDate: 2007-03-30 21:46:35
Subject: Re: Shared buffers, db transactions commited, and write IO on Solaris
Previous:From: Scott MarloweDate: 2007-03-30 21:41:43
Subject: Re: scalablility problem

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