| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2007-03-30 21:46:35 | Re: Shared buffers, db transactions commited, and write IO on Solaris |
| Previous Message | Scott Marlowe | 2007-03-30 21:41:43 | Re: scalablility problem |