Avoid PostgreSQL LWLock:buffer_content locks in Amazon Aurora: Tips and best practices
Avoid PostgreSQL LWLock:buffer_content locks in Amazon Aurora: Tips and best practices - Sami Imseih, Yahav Biran | Percona Live 2022. We have seen #PostgreSQL customers facing buffer_content locks caused by contention of data in high concurrency or large datasets(96vCPUs, 768GiB with 30TB). Likeđź‘Ť Commentđź’¬ Shaređź”— Subscribeâś… and tap the đź”” to be the first to see new videos on #OpenSource #Databases & more! https://percona.tv/subscribe We provide a benchmark and share tips with a real-world workload that leads to buffer_lock contentions. We then propose the patterns to minimize the chance for buffer_content locks.
▶︎
Overcome Blast Radius Anxiety With Ultrafast Rebuilds and Performance for High-capacity SSDs
▶︎
MCP vs API: Simplifying AI Agent Integration with External Data
▶︎
Optimizing autovacuum: PostgreSQL’s vacuum cleaner | Citus Con: An Event for Postgres 2022
▶︎
Optimizing Postgres for write heavy workloads ft. Checkpoint and WAL configs | Citus Con 2023
▶︎
Turing Award Winner: Disagreeing with Google, Postgres, Future Problems | Mike Stonebraker
▶︎
Ex-Google Recruiter Explains Why "Lying" Gets You Hired
▶︎
Building the PERFECT Linux PC with Linus Torvalds
▶︎
How Netflix Uses Java - 2026 Edition
▶︎
Sarah Paine - Why Putin and Xi can't escape geography
▶︎
5 Secrets for making PostgreSQL run BLAZING FAST. How to improve database performance.
▶︎
Palantir and Switzerland – Between Data and Power | Reporter | SRF
▶︎
Andrej Karpathy: From Vibe Coding to Agentic Engineering w/ Stephanie Zhan
▶︎
HISTORIC COMEBACK BY THE GREATEST JAPANESE GENERATION OF ALL TIME AGAINST ANCELOTTI’S BRAZIL
▶︎
Deep Dive on Amazon Aurora PostgreSQL Performance Tuning
▶︎
How Rockstar fit an entire city into PlayStation 2 memory
▶︎
Solving one of PostgreSQL's biggest weaknesses.
▶︎
PgBouncer Tutorial
▶︎
Why Gen Z Filipinos Are Giving Up on Dating and Marriage | AB Explained
▶︎
AWS re:Invent 2025 - PostgreSQL performance: Real-world workload tuning (DAT410)
▶︎