Re: Straightforward changes for increased SMP scalability

Поиск
Список
Период
Сортировка
От Strong, David
Тема Re: Straightforward changes for increased SMP scalability
Дата
Msg-id B6419AF36AC8524082E1BC17DA2506E803CE92DF@USMV-EXCH2.na.uis.unisys.com
обсуждение исходный текст
Ответ на Re: Straightforward changes for increased SMP scalability  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
>> I'm happy to run some benchmarks to show the improvements with
various
>> NUM_BUFFER_PARTITIONS settings. However, I want to make sure that
this
>> is going to be useful. I can run 16 (base), 32, 64, 128 etc. type
>> increments, but I'm more concerned about the number of cores to use.
Do
>> you have a suggestion for that? I can run with 1 to 32 cores. I had
>> planned to run a number of tests at 8 cores, but I can adjust to what
?> makes sense for the community.
>
>Presumably the answers will be different.  I'd sort of like to see
>several different curves for different numbers of processors, so we
>can evaluate reasonably fairly.
>
>            regards, tom lane

Tom,

Correct. This is a scalability patch rather than a performance patch,
although each aspect is related. I would expect the gain to be better as
more cores and users are added.

I can run some tests along the following lines:

1. NUM_BUFFER_PARITIONS sizes for 16, 32, 64, 128, 256, 512, 1024, 2048.

2. Cores set at 1, 2, 4, 8, 16, 24 and 32.

Does anyone have any comments or suggestions?

David


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Straightforward changes for increased SMP scalability
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Straightforward changes for increased SMP scalability