Re: SMP scaling

Поиск
Список
Период
Сортировка
От Mark Rae
Тема Re: SMP scaling
Дата
Msg-id 20050318160808.GA27953@purplebat.com
обсуждение исходный текст
Ответ на Re: SMP scaling  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: SMP scaling  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SMP scaling
Следующее
От: Rafael Martinez
Дата:
Сообщение: Re: pg_dump large-file support > 16GB