Re: scalablility problem - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: scalablility problem
Date
Msg-id 1175291079.25022.114.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: scalablility problem  (Xiaoning Ding <dingxn@cse.ohio-state.edu>)
List 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.

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: scalablility problem
Next
From: Josh Berkus
Date:
Subject: Re: Shared buffers, db transactions commited, and write IO on Solaris