Re: Make NUM_XLOGINSERT_LOCKS configurable - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Make NUM_XLOGINSERT_LOCKS configurable
Date
Msg-id 2332382.1704861023@sss.pgh.pa.us
Whole thread Raw
In response to Re: Make NUM_XLOGINSERT_LOCKS configurable  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Make NUM_XLOGINSERT_LOCKS configurable
List 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 by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Test slots invalidations in 035_standby_logical_decoding.pl only if dead rows are removed
Next
From: Shlok Kyal
Date:
Subject: Re: speed up a logical replica setup