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.

Видео Avoid PostgreSQL LWLock:buffer_content locks in Amazon Aurora: Tips and best practices автора Python виртуализация