Re: Guideline To Resolve LWLock:SubtransControlLock
Thanks. How do we go about calculating appropriate values for these two parameters ... > 'NUM_SUBTRANS_BUFFERS'? TOTAL_MAX_CACHED_SUBXIDS And do both require a recompile? - Thank you. On Aug 17, 2018, at 2:26 PM, Alvaro Herrera wrote: >> And as for the recompile, are you thinking 'NUM_SUBTRANS_BUFFERS'? > > Yes, that's one option, but there's also TOTAL_MAX_CACHED_SUBXIDS.
Re: Guideline To Resolve LWLock:SubtransControlLock
On 2018-Aug-20, Fred Habash wrote: > How do we go about calculating appropriate values for these two parameters ... I don't know a lot about your system, so don't have anything to go on. Also, Aurora is mostly unknown to me. What did Amazon say? > > 'NUM_SUBTRANS_BUFFERS'? > TOTAL_MAX_CACHED_SUBXIDS > > And do both require a recompile? Yes. But maybe they'll just move the contention point a little bit backwards without actually fixing anything. -- Álvaro Herrerahttps://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
