Re: Guideline To Resolve LWLock:SubtransControlLock

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Fred Habash <fmhabash(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Guideline To Resolve LWLock:SubtransControlLock
Date: 2018-08-20 21:00:27
Message-ID: 20180820210027.iu3pryzkfssmptco@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeremy Schneider 2018-08-20 22:14:49 Re: Guideline To Resolve LWLock:SubtransControlLock
Previous Message Fred Habash 2018-08-20 20:52:47 Re: Guideline To Resolve LWLock:SubtransControlLock