Re: Guideline To Resolve LWLock:SubtransControlLock

2018-08-16 Thread Alvaro Herrera
On 2018-Aug-16, Fred Habash wrote: > One of our database API's is run concurrently by near 40 sessions. We see > all of them waiting back and forth on this wait state. What version are you running? > Why is it called Subtrans Control Lock? It controls access to the pg_subtrans structure, which

Guideline To Resolve LWLock:SubtransControlLock

2018-08-16 Thread Fred Habash
One of our database API's is run concurrently by near 40 sessions. We see all of them waiting back and forth on this wait state. There is one scenario described in some forum where sessions connected a read-only replica are affected. This does not apply to our use case. Why is it called Subtrans