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! 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.

Пікірлер: 1

  • @user-kh7nl8sv1j
    @user-kh7nl8sv1j Жыл бұрын

    I didn't get what kind of partition algorithm was used? Its not always possible to split hot and cold data, if just randomly split records between partitions will it have an effect on LwLocks problem?

Келесі