Re: lazy vxid locks, v1

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: lazy vxid locks, v1
Дата
Msg-id 4DF5BC4E020000250003E50D@gw.wicourts.gov
обсуждение исходный текст
Ответ на lazy vxid locks, v1  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: lazy vxid locks, v1  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Список pgsql-hackers
Stefan Kaltenbrunner  wrote:
> on that particular 40cores/80 threads box:
> unpatched:
> c40:    tps = 107689.945323 (including connections establishing)
> c80:    tps = 101885.549081 (including connections establishing)
> fast locks:
> c40:    tps = 215807.263233 (including connections establishing)
> c80:    tps = 118266.615543 (including connections establishing)
> fast locks + lazy vxid:
> c40:    tps = 223308.779212 (including connections establishing)
> c80:    tps = 65738.046558 (including connections establishing)
Is there any way to disable the HT (or whatever technology attempts
to make each core look like 2)?  In my benchmarking that has kept
performance from tanking as badly when a large number of processes
are contending for CPU.
-Kevin


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: wrong message on REASSIGN OWNED
Следующее
От: Robert Haas
Дата:
Сообщение: Re: FOREIGN TABLE doc fix