“Don’t mock what you don't own” in 5 minutes (2022) (hynek.me)
15 points by JNRowe 2d ago 6 comments
The Travel Writer's Dilemma: Share, or Gatekeep? (nytimes.com)
10 points by Thevet 3d ago 1 comments
The magic of through running (worksinprogress.news)
172 points by ortegaygasset 23h ago 111 comments
Pglocks.org
80 hnasr 12 5/18/2025, 3:13:47 AM pglocks.org ↗
* Unlocking the Postgres Lock Manager by Bruce Momjian: https://momjian.us/main/writings/pgsql/locking.pdf
* Anatomy of table-level locks by Gulcin Yildirim Jelinek: https://xata.io/blog/anatomy-of-locks
The rationale being to have a "lock diagnostics report" commented in your PR's migration file.
It's a prototype and has a few rough edges and missing functionality, but feedback is more than welcome.
[1] https://github.com/agis/pglockanalyze
Locking is a challenging problem in complex systems. Is this list to be interpreted as a "TODO: get rid of locking conflicts in future releases" or more a "NOTE: be aware there are known conflicts that will not change - find ways to work around them"?
EDIT: Also, is the creation of this list an automated or a manual effort?
Usually for maximum performance (minimum latency, maximum throughput) you want to have operations not lock each other, unless absolutely necessary, in which case you want them to be short.
I actually like this a lot, as there isn't a single place in the Postgres documentation that lists all the possible locks; it's spread out all over. Having a quick reference for what kinds of commands you'd be blocking with your transaction is valuable.
It's pretty evident that the pages have been programmatically generated, but I'd love know what it's generated from. I think you can derive this information from the documentation, but not sure if you can do it in an automated way without an LLM.
Did you read this page? https://www.postgresql.org/docs/current/explicit-locking.htm...
First, it isn't complete; as I said, the locking behaviour is spread out all over the Postgres documentation. For example, that page doesn't list what locks DROP INDEX takes. To find that out, you have to go to the documentation page for that command and read it carefully. In fact, really carefully — the locking behaviour is only documented under the section about CONCURRENTLY.
The page also doesn't list what possible commands are then blocked. Locks interact in subtle (and incorrectly named!) ways that are explained in the tables on that page ("Conflicting lock modes"), so to understand if something will block something else you have to look at the two commands you are curious about and then look at how their locks interact.
The locks are here by necessity, it is not so easy at all to get rid of them. And even in special cases where it is possible, the complexity you have to introduce is not to be taken lightly...
If even a tenth of these disapppeared, it would be incredible, in a very surprising way.