Top all-time · #18317
Adrien Nayrat
Personal blog · blog.anayrat.infodataprogramming
Adrien Nayrat's personal blog at blog.anayrat.info covers data and programming. Since 2018, 4 different Hacker News readers have linked it 5 times. The last post was in 2024, 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 cite this blog's PostgreSQL posts on JSONB and indexing. They are linked as sources explaining the statistics and functional-index problems discussed in threads on Postgres performance.
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.
Blog de Adrien Nayrat. DBA PostgreSQL Freelance.
Most-linked posts?
- /en/2017/11/26/postgresql---jsonb-and-statistics/2 people · 2 mentions · first linked 2018-03-06
What Hacker News says?
https://blog.anayrat.info/en/2017/11/26/postgresql---jsonb-a... explains this problem in more detail.
Comment linking /en/2017/11/26/postgresql---jsonb-and-statistics/
on “Create Statistics in PostgreSQL 10”Submitted PostgreSQL's developments for high volumes processing as a story · 5 points
HN discussionYou can get around that with functional indexes https://blog.anayrat.info/en/2017/11/26/postgresql---jsonb-a... I'm not working with tens of millions of records, but I haven't needed to go beyond GIN indexes yet - might just be our documents or our workload though. ymmv.
Comment linking /en/2017/11/26/postgresql---jsonb-and-statistics/
on “Ask HN: Have you ever chosen Postgres over Mongo and regretted it?”Submitted Recommended resources to improve your knowledge of Databases and PostgreSQL as a story · 3 points
HN discussionSubmitted Postgres again elected DBMS of the Year in 2023, but I'm worried as a story · 2 points
HN discussion