Re: SMP scaling - Mailing list pgsql-general

From Tom Lane
Subject Re: SMP scaling
Date
Msg-id 6871.1111160304@sss.pgh.pa.us
Whole thread Raw
In response to SMP scaling  (Mark Rae <mrae@purplebat.com>)
Responses Re: SMP scaling
List pgsql-general
Mark Rae <mrae@purplebat.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: plpython function problem workaround
Next
From: Mark Rae
Date:
Subject: Re: SMP scaling