Fw: [HACKERS] HACKERS[PATCH] split ProcArrayLock into multiple parts --follow-up

Поиск
Список
Период
Сортировка
От Jim Van Fleet
Тема Fw: [HACKERS] HACKERS[PATCH] split ProcArrayLock into multiple parts --follow-up
Дата
Msg-id OF1D4EE456.7DC4EAD5-ON862581A2.00714E01-862581A2.00729C6E@notes.na.collabserv.com
обсуждение исходный текст
Ответы Re: Fw: [HACKERS] HACKERS[PATCH] split ProcArrayLock into multipleparts -- follow-up  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Дерево обсуждения
Howdy --

Not to beat on a dead horse, or anything, but this fix was frowned upon because in one environment (one socket) it was 6% down and over 15% up in the right environment (two sockets).

So, why not add a configuration parameter which specifies the number of parts? Default is 1 which would be "exactly" the same as no parts and hence no degradation in the single socket environment -- and with 2, you get some positive performance.

Jim
----- Forwarded by Jim Van Fleet/Austin/Contr/IBM on 09/21/2017 03:37 PM -----

pgsql-hackers-owner@postgresql.org wrote on 06/09/2017 01:39:35 PM:

> From: "Jim Van Fleet" <vanfleet@us.ibm.com>
> To: "Pgsql Hackers" <pgsql-hackers@postgresql.org>
> Date: 06/09/2017 01:41 PM
> Subject: [HACKERS] HACKERS[PATCH] split ProcArrayLock into multiple parts
> Sent by: pgsql-hackers-owner@postgresql.org
>
> I left out the retry in LWLockAcquire.
>
> [attachment "ProcArrayLock_part.patch" deleted by Jim Van Fleet/
> Austin/Contr/IBM]
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] hash index on unlogged tables doesn't behave as expected
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: [HACKERS] CREATE COLLATION does not sanitize ICU's BCP 47language tags. Should it?