Re: SMP scaling

Mark Rae wrote:
> 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.

So it seems our entire SMP problem was that global lock. Nice.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073