Re: Guideline To Resolve LWLock:SubtransControlLock

[Fred Habash <fmhabash@xxxxxxxxx>]

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 <alvherre@xxxxxxxxxxxxxxx> 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.