Re: Linux: more cores = less concurrency.
От | Kevin Grittner |
---|---|
Тема | Re: Linux: more cores = less concurrency. |
Дата | |
Msg-id | 4DA32DE3020000250003C68E@gw.wicourts.gov обсуждение исходный текст |
Ответ на | Re: Linux: more cores = less concurrency. ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>) |
Ответы |
Re: Linux: more cores = less concurrency.
|
Список | pgsql-performance |
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> wrote: > I don't know why you were hitting the knee sooner than I've seen > in my benchmarks If you're compiling your own executable, you might try boosting LOG2_NUM_LOCK_PARTITIONS (defined in lwlocks.h) to 5 or 6. The current value of 4 means that there are 16 partitions to spread contention for the lightweight locks which protect the heavyweight locking, and this corresponds to your best throughput point. It might be instructive to see what happens when you tweak the number of partitions. Also, if you can profile PostgreSQL at the sweet spot and again at a pessimal load, comparing the profiles should give good clues about the points of contention. -Kevin
В списке pgsql-performance по дате отправления: