Top all-time · #17827
Thomas Munro
Personal blog · write-skew.blogspot.comprogrammingsystemsdata
Thomas Munro writes Write Skew, a personal blog at write-skew.blogspot.com about programming, systems and data. Since 2018, 4 different Hacker News readers have linked it 7 times, most often “Parallel Hash for PostgreSQL”. The last post was in 2018, but the archive is still widely read.
Too few sampled comments (2) to say how often HN recommends it.?
Why HN links it
HN readers link this blog for in-depth posts on PostgreSQL internals, including parallel query and parallel hash joins, and on serializable isolation (SSI versus strict two-phase locking).
Summarised by Claude from a sample of 2 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
A blog mostly about PostgreSQL by Thomas Munro
Most-linked posts?
- Parallel Hash for PostgreSQL4 people · 4 mentions · first linked 2018-01-10
What Hacker News says?
The section on parallel joins is a bit out of date. Shameless plug: I've written and spoken about this subject extensively, if you are looking for more information, with further links and pointers to other blogs and academic papers. Parallelism in PostgreSQL in general: https://speakerdeck.com/macdice/parallelism-in-postgresql-11 Deeper dives on hash joins: https://write-skew.blogspot.com/2018/01/parallel-hash-for-p…
Comment linking /2018/01/parallel-hash-for-postgresql.html
on “Parallelism in PostgreSQL”Submitted Parallel Hash for PostgreSQL as a story · 5 points
HN discussionFirst, note that PostgreSQL uses SSI, an optimistic strategy for implementing SERIALIZABLE, so it neeeds to be able to nuke transactions that cannot be proven to be safe. This is a trade-off; other systems use (pessimistic) strict two-phase locking and similar, and we are taking the bet that the total throughput will be higher with SSI than with S2PL. Usually that optimism turns out to be right (though not for all w…
Comment linking /2018/05/serializable-in-postgresql-11-and-beyond.html
on “Serializability vs. Strict Serializability: The Dirty Secret of Isolation Levels”Submitted Parallel Hash for PostgreSQL as a story · 4 points
HN discussionSubmitted Parallel Hash for PostgreSQL as a story · 4 points
HN discussionSubmitted SERIALIZABLE in PostgreSQL 11 and beyond as a story · 3 points
HN discussionSubmitted Write Skew: Parallel Hash for PostgreSQL as a story · 3 points
HN discussion