Top all-time · #21322
Andres Freund
Personal blog · blog.anarazel.dedatasystems
Andres Freund writes Postgres From Below, a personal blog at blog.anarazel.de about data and systems. Since 2020, 3 different Hacker News readers have linked it 4 times, most often “Measuring the Memory Overhead of a Postgres Connection”. The last post was in 2020, 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 Andres Freund's Postgres posts on memory and scalability, including measurements of per-connection memory overhead and his work on snapshot scalability for connection handling.
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.
Andres Freund's blog
Most-linked posts?
- Measuring the Memory Overhead of a Postgres Connection3 people · 4 mentions · first linked 2020-10-08
What Hacker News says?
I find the "pg connections take a lot of memory" to be mostly a myth. The number floating around is 10 - 20MB per connection but it looks it's more like 2MB per connection https://blog.anarazel.de/2020/10/07/measuring-the-memory-ove...
Comment linking /2020/10/07/measuring-the-memory-overhead-of-a-postgres-connection/
on “How to get the most out of Postgres memory settings”Submitted Measuring the Memory Overhead of a Postgres Connection as a story · 62 points
HN discussion> I do not understand why people aren't clamouring against postgres's connection model. There are people wanting to change that - including me, the author of the blog post. I explained in an earlier blog post ([1]) why I chose to work on making snapshots more scalable at this time: > Lastly, there is the aspect of wanting to handle many tens of thousands of connections, likely by entirely switching the connection mo…
Comment linking /2020/10/07/measuring-the-memory-overhead-of-a-postgres-connection/
on “Improving Postgres Connection Scalability: Snapshots”Submitted Measuring the Memory Overhead of a Postgres Connection as a story · 4 points
HN discussion