5mins of Postgres E25: Postgres lock monitoring, LWLocks and the log_lock_waits setting
Today, we are talking about Postgres locking. When it is concerning, what lightweight locks are, as well as the log_lock_waits setting in Postgres.
Find the article on our blog here: https://pganalyze.com/blog/5mins-post...
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
📑 What we have discussed in this episode of 5mins of Postgres:
- Postgres Locking: When is it Concerning? https://www.crunchydata.com/blog/post...
- David Christensen on Twitter / pg_dwc
- pg_blocking_pids function https://www.postgresql.org/docs/curre...
- Avoid PostgreSQL LWLock:buffer_content locks in Amazon Aurora: Tips and best practices https://aws.amazon.com/blogs/database...
- Postgres Source Code Docs: Locking Overview https://github.com/postgres/postgres/...
- Simple test for lock_waits log messages https://gorthx.wordpress.com/2015/05/...
- gorthx on Twitter / gorthx
- Postgres Log Monitoring 101: Deadlocks, Checkpoint Tuning & Blocked Queries https://pganalyze.com/blog/postgresql...
- Log Insights: Lock Events - L71: Process still waiting for lock on tuple / relation / object https://pganalyze.com/docs/log-insigh...
- Log Insights: Lock Events - L70: Process acquired lock on tuple / relation / object https://pganalyze.com/docs/log-insigh...
- What is the performance cost of enabling "log_lock_waits" on Postgres? https://dba.stackexchange.com/questio...