RE: Guideline To Resolve LWLock:SubtransControlLock

Thanks, Jeremy … “ That said... FWIW, Aurora PostgreSQL version 9.6.3 uses parent/child transaction relationships pretty much the same way that community PostgreSQL 9.6.3 does …” This is why I posted here first. This particular wait state did not appear to be Aurora specific and was not listed

RE: Guideline To Resolve LWLock:SubtransControlLock

Jeremy … In your statement, what constitutes ‘heavy use of exception blocks’? Thanks I have seen applications grind to a halt on SubtransControlLock when they make heavy use of exception blocks in plpgsql code; in fact it's pretty straightforward to demonstrate this behavior with pgbench on