#PostgresMarathon 2-001: Lightweight and heavyweight locks | PostgresAI
To warm up, let's talk about lightweight and heavyweight locks (or "regular locks" or just "locks").| PostgresAI
The setting maxlockspertransaction is mysterious, it is a good illustration of Socrates' "I know that I know nothing". This is the main fact to memorize about maxlockspertransaction. Don't try to remember details. Unless you touch it often, you'll forget (I do). Instead, let's rely on the docs:|
In 2023-2024, after incidents that multiple customers of PostgresAI experienced, when production nodes were down because of LWLock:LockManager contention, we studied it in synthetic environments.|
After 2-003, @ninjouz asked on X:|
As we discussed, Lock Manager manages heavyweight locks – various kinds of them (various modes, various levels of granularity). These locks are released only at the end of the transaction.|
Let's talk about relation-level locks and various confusions, surprises and what is worth to remember in practice.|
To warm up, let's talk about lightweight and heavyweight locks (or "regular locks" or just "locks").| PostgresAI
Honoring a Legacy of Standards and Safety Did you know that the Builders Hardware Manufacturers Association (BHMA) is turning 100 this year? For a century,... The post A Century of Standards: BHMA Celebrates 100 Years This Fall appeared first on The ANSI Blog.| The ANSI Blog
I once wrote about this problem, but given that we now have DO blocks and procedures I can make nicer, easy to use example. Over the years there have been many improvements to how long ALTER TABLE can take. You can now (in some cases) change datatype without rewrite or add default value. Regardless how … Continue reading "How to ALTER tables without breaking application?"| select * from depesz;
