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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073