Are you using PostGIS?
If so, there is an issue with TOAST table locking having these symptoms.
---Paul
On Wed, Oct 13, 2021 at 11:15 AM MichaelDBA wrote:
> 1.Is there a way to tune the lock contention ?
> 2.Is any recommendations to tune/reduce the lock contention via postgres.conf
>
> I th
he requested improvement I was thinking of was to have the
locks on the toast table somehow have the same lifespan as the locks on
the main table to avoid this problem to begin with.
---Paul
Paul Friedman
CTO
677 Harrison St | San Francisco, CA 94107
M: (650) 270-7676
E-mail
_toast_2233612264" is not a table or view"
Sounds like I should file this as a requested improvement?
Thanks again.
---Paul
Paul Friedman
CTO
677 Harrison St | San Francisco, CA 94107
M: (650) 270-7676
E-mail: paul.fried...@streetlightdata.com
-Original Message-
From: And
Thanks for this – these tools (and the raw selects on pg_stat_activity and
pg_locks) are all showing wait events being created by LockManager waiting
on an LWLock.
---Paul
Paul Friedman
CTO
677 Harrison St | San Francisco, CA 94107
*M:* (650) 270-7676
*E-mail:* paul.fried
continued help!
---Paul
Paul Friedman
CTO
677 Harrison St | San Francisco, CA 94107
M: (650) 270-7676
E-mail: paul.fried...@streetlightdata.com
-Original Message-
From: Andres Freund
Sent: Monday, April 12, 2021 4:04 PM
To: Paul Friedman
Cc: pgsql-performance@lists.postgresql.org
S
?
Thanks.
---Paul
Paul Friedman
CTO
677 Harrison St | San Francisco, CA 94107
M: (650) 270-7676
E-mail: paul.fried...@streetlightdata.com
-Original Message-
From: Andres Freund
Sent: Monday, April 12, 2021 3:22 PM
To: Paul Friedman
Cc: pgsql-performance@lists.postgresql.org
Subject: R
Client ClientRead 1
background writer ActivityBgWriterMain 1
walwriter ActivityWalWriterMain 1
Thanks again for any advice you have.
---Paul
Paul Friedman
CTO
677 Harrison St | San Francisco, CA 94107
M: (650
locks yields lots of records looking like:
[39691] LOG: 39691: LWLockAcquire(LockManager 0x7fab2cc09d80): excl 0
shared 0 haswaiters 1 waiters 6 rOK 1
Does anyone have any advice on how to alleviate LockManager’s LWlock issue?
Thanks for any assistance!
---Paul
Paul Friedman
CTO
677
