Work in progress: 181,232 of 181,233 sites checked so far, more every week · updated 2 Nov 2026Missing a blog? Tell us

Top all-time · #18317

A

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.

Visit the blog
5mentions?
4HN people?
2018–2024first – last linked?
Links on Hacker News per year · peak 3 in 2018

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?

  1. /en/2017/11/26/postgresql---jsonb-and-statistics/
    2 people · 2 mentions · first linked 2018-03-06

What Hacker News says?

  1. 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”
  2. Submitted PostgreSQL's developments for high volumes processing as a story · 5 points

    HN discussion
  3. You 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?”
  4. Submitted Recommended resources to improve your knowledge of Databases and PostgreSQL as a story · 3 points

    HN discussion
  5. Submitted Postgres again elected DBMS of the Year in 2023, but I'm worried as a story · 2 points

    HN discussion

Search all of HN for blog.anayrat.info