| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Mark Rae <mrae(at)purplebat(dot)com> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, postgres list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: SMP scaling |
| Date: | 2005-03-18 15:38:24 |
| Message-ID: | 6871.1111160304@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Mark Rae <mrae(at)purplebat(dot)com> writes:
> Ok, I've done the tests comparing 8.0.1 against a snapshot from the 16th
> and the results are impressive.
> Clients 1 2 3 4 6 8 12 16 32 64
> ---------------------------------------------------------------------------------------
> Altix pg-8.0.1 1.00 2.02 2.98 3.97 5.87 7.23 7.51 5.54 4.68 5.10
> Altix pg-20050316 1.00 1.97 2.86 3.68 5.29 6.90 9.00 9.88 10.03 9.94
> AMD64 pg-8.0.1 1.00 1.87 2.77 3.34 2.73 2.57 2.58 2.62
> AMD64 pg-20050316 1.00 1.95 2.84 3.69 3.61 3.66 3.70 3.69
> IA64 pg-8.0.1 1.00 1.97 2.91 3.82 2.91 2.92 2.94 2.98
> IA64 pg-20050316 1.00 1.98 2.95 3.87 3.80 3.78 3.86 3.90
Hey, that looks pretty sweet. One thing this obscures though is whether
there is any change in the single-client throughput rate --- ie, is "1.00"
better or worse for CVS tip vs 8.0.1?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Rae | 2005-03-18 16:08:08 | Re: SMP scaling |
| Previous Message | Tom Lane | 2005-03-18 15:33:01 | Re: plpython function problem workaround |