| From: | Mark Rae <mrae(at)purplebat(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| 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 16:08:08 |
| Message-ID: | 20050318160808.GA27953@purplebat.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Mar 18, 2005 at 10:38:24AM -0500, Tom Lane wrote:
> 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?
Here are the figures in queries per second.
Clients 1 2 3 4 6 8 12 16 32 64
---------------------------------------------------------------------------------------
AMD64 pg-8.0.1 6.80 12.71 18.82 22.73 18.58 17.48 17.56 17.81
AMD64 pg-20050316 6.80 13.23 19.32 25.09 24.56 24.93 25.20 25.09
IA64 pg-8.0.1 3.72 7.32 10.81 14.21 10.81 10.85 10.92 11.09
IA64 pg-20050316 3.99 7.92 11.78 15.46 15.17 15.09 15.41 15.58
Altix pg-8.0.1 3.66 7.37 10.89 14.53 21.47 26.47 27.47 20.28 17.12 18.66
Altix pg-20050316 3.83 7.55 10.98 14.10 20.27 26.47 34.50 37.88 38.45 38.12
So, it didn't make any difference for the Opteron, but the two
Itanium machines were 5% and 7% faster respectively.
-Mark
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rick Schumeyer | 2005-03-18 16:17:57 | performance: pg vs pg! |
| Previous Message | Tom Lane | 2005-03-18 15:38:24 | Re: SMP scaling |