Re: Guideline To Resolve LWLock:SubtransControlLock

2018-08-20 Thread Alvaro Herrera
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_SU

Re: Guideline To Resolve LWLock:SubtransControlLock

2018-08-20 Thread Fred Habash
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