Postgres Pro
Downloads
Home   >   mailing lists

Re: Guideline To Resolve LWLock:SubtransControlLock - Mailing list pgsql-performance

From Fred Habash
Subject Re: Guideline To Resolve LWLock:SubtransControlLock
Date
Msg-id 82F3FC39-72DA-4C25-804A-212DE0E5ECB3@gmail.com
Whole thread Raw
In response to Re: Guideline To Resolve LWLock:SubtransControlLock  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: Guideline To Resolve LWLock:SubtransControlLock
List pgsql-performance
Tree view
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@2ndquadrant.com> 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.

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Guideline To Resolve LWLock:SubtransControlLock
Next
From: Alvaro Herrera
Date:
Subject: Re: Guideline To Resolve LWLock:SubtransControlLock