LWLocks | Postgres.FM 162 |
[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
Nik and Michael discuss lightweight locks in Postgres — how they differ to (heavier) locks, some occasions they can be troublesome, and some resources for working out what to do if you hit issues.
Here are some links to things they mentioned:
Wait Events of Type LWLock https://www.postgresql.org/docs/curre...
Our episode on (heavier) locks https://postgres.fm/episodes/locks
Nik’s new marathon posts https://postgres.ai/blog/tags/postgre...
Postgres LISTEN/NOTIFY does not scale (blog post by Recall ai) https://www.recall.ai/blog/postgres-l...
Explicit Locking https://www.postgresql.org/docs/curre...
pg_stat_activity https://www.postgresql.org/docs/curre...
Tuning with wait events for RDS for PostgreSQL https://docs.aws.amazon.com/AmazonRDS...
MultiXact member exhaustion incidents (blog post by Cosmo Wolfe / Metronome) https://metronome.com/blog/root-cause...
pg_index_pilot https://gitlab.com/postgres-ai/pg_ind...
Myths and Truths about Synchronous Replication in PostgreSQL (talk by Alexander Kukushkin) • Myths and Truths about Synchronous Replica...
Postgres Indexes, Partitioning and LWLock:LockManager Scalability (blog post by Jeremy Schneider) https://ardentperf.com /2024/03/03/postgres-indexes-partitioning-and-lwlocklockmanager-scalability
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @postgresfm / postgresfm , @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is produced by:
Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/
Michael Christofides, founder of pgMustard https://pgmustard.com/
~~~
This is the video version. Check out https://postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.
On this page of the site you can watch the video online LWLocks | Postgres.FM 162 | with a duration of hours minute second in good quality, which was uploaded by the user PostgresTV 01 January 1970, share the link with friends and acquaintances, this video has already been watched 702 times on youtube and it was liked by 29 viewers. Enjoy your viewing!
