Troubleshooting row lock contention in Amazon Aurora PostgreSQL: Part 1 – Understanding row lock contention in PostgreSQL
Row lock contention can collapse database throughput during a flash sale even when CPU and I/O look healthy.
Useful takeaways from this story.
Row lock contention can collapse database throughput during a flash sale even when CPU and I/O look healthy.
In Part 1 of this series, learn how PostgreSQL row locking works and how to monitor lock contention in Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL using system views, the pgrowlocks extension,...
Building the complete brief
The page is ready to read now. The fuller skim-friendly version will appear here automatically.
The useful part
Row lock contention can collapse database throughput during a flash sale even when CPU and I/O look healthy. In Part 1 of this series, learn how PostgreSQL row locking works and how to monitor lock contention in Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL using system views, the pgrowlocks extension, and the log_lock_waits parameter.
How it works
- In Part 1 of this series, learn how PostgreSQL row locking works and how to monitor lock contention in Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL using system views, the pgrowlocks extension,...
Keep reading in the app
Open the app view to save this story, compare related coverage, and continue from the same source.