Re: Make NUM_XLOGINSERT_LOCKS configurable

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Make NUM_XLOGINSERT_LOCKS configurable
Дата
Msg-id 2332382.1704861023@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Make NUM_XLOGINSERT_LOCKS configurable  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: Make NUM_XLOGINSERT_LOCKS configurable  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Список pgsql-hackers
Michael Paquier <michael@paquier.xyz> writes:
> This suggestion has showed up more than once in the past, and WAL
> insertion is a path that can become so hot under some workloads that
> changing it to a GUC would not be wise from the point of view of
> performance.  Redesigning all that to not require a set of LWLocks
> into something more scalable would lead to better result, whatever
> this design may be.

Maybe.  I bet just bumping up the constant by 2X or 4X or so would get
most of the win for far less work; it's not like adding a few more
LWLocks is expensive.  But we need some evidence about what to set it to.

            regards, tom lane



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Test slots invalidations in 035_standby_logical_decoding.pl only if dead rows are removed
Следующее
От: Shlok Kyal
Дата:
Сообщение: Re: speed up a logical replica setup