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

Top all-time · #2020

H

Hironobu Suzuki

Personal blog · interdb.jpdataprogrammingsystems

Hironobu Suzuki writes Hironobu SUZUKI @ InterDB, a personal blog at interdb.jp about data, programming and systems. Since 2016, 39 different Hacker News readers have linked it 43 times, most often “The internals of PostgreSQL”. The last post was in 2022, but the archive is still widely read.

Visit the blog
43mentions?
39HN people?
2016–2026first – last linked?
Links on Hacker News per year · peak 11 in 2022

Most-linked posts?

  1. The internals of PostgreSQL
    9 people · 9 mentions · first linked 2016-07-22
  2. The Internals of PostgreSQL
    8 people · 9 mentions · first linked 2022-02-10
  3. The Internals of PostgreSQL
    7 people · 7 mentions · first linked 2017-02-09
  4. The Internals of Postgres – Concurrency Control
    3 people · 3 mentions · first linked 2018-05-01
  5. /blog/pgsql/pg_pacemaker_01/
    2 people · 2 mentions · first linked 2017-02-09
  6. /pg/faq.html
    2 people · 2 mentions · first linked 2022-01-26
  7. /pg/pgsql09.html
    2 people · 2 mentions · first linked 2020-04-04
  8. The Internals of PostgreSQL
    2 people · 2 mentions · first linked 2022-01-26

What Hacker News says?

  1. afarrell · 2017-02-09
    If you're looking to learn a mental model of the internals, a coworker has pointed me at http://www.interdb.jp/pg/ and it's pretty good.

    Comment linking /pg/

    on “RethinkDB versus PostgreSQL: my personal experience”
  2. adamnemecek · 2017-01-26

    Submitted The internals of PostgreSQL as a story · 477 points

    HN discussion
  3. evil-olive · 2019-04-24
    I haven't fully read it (yet), but based on a quick scan of a few chapters, it looks like a dense but well-written introduction. Some additional resources I'd recommend if you're interested: Designing Data-Intensive Applications is a fantastic place to start if you're interested in the intersection of databases & distributed systems: https://dataintensive.net/ The Architecture of Open-Source Applications book has a…

    Comment linking /pg/index.html

    on “Foundations of Databases (1995)”
  4. billwashere · 2019-01-20

    Submitted Internals of PostgreSQL as a story · 464 points

    HN discussion
  5. codetrotter · 2019-01-20
    Following the link to the blog of the author I found a blog post titled “postgres cluster management system in GoCardless” http://www.interdb.jp/blog/pgsql/pg_pacemaker_01/ Which in turn lead me to https://github.com/gocardless/our-postgresql-setup And in turn to a fifteen minute talk titled “Zero-downtime Postgres upgrades” https://www.youtube.com/watch?v=SAkNBiZzEX8 Which was interesting and informative IMO. After…

    Comment linking /blog/pgsql/pg_pacemaker_01/

    on “Internals of PostgreSQL”
  6. kklisura · 2022-01-26

    Submitted The Internals of PostgreSQL as a story · 328 points

    HN discussion
  7. rrampage · 2022-07-14
    Postgrespro's blog ( https://habr.com/en/company/postgrespro/blog/ ) and http://www.interdb.jp/pg/index.html are incredible resources to learn about Postgres internals in depth. Are there resources of similar quality available for MySQL / MariaDB internals ?

    Comment linking /pg/index.html

    on “PostgreSQL 14 Internals Book”
  8. hjnkk · 2022-02-17

    Submitted The Internals of PostgreSQL as a story · 279 points

    HN discussion
  9. Erwin · 2022-07-13
    If you want more, here's another site with similar focus: http://www.interdb.jp/pg/index.html

    Comment linking /pg/index.html

    on “PostgreSQL 14 Internals Book”
  10. shxx · 2024-07-16

    Submitted The Engineer’s Guide to Deep Learning: Understanding the Transformer Model as a story · 258 points

    HN discussion
  11. rtpg · 2022-02-10
    For people interested in more details about Postgres internals I cannot recommend https://www.interdb.jp/pg/ enough, an excellent text with lots of details

    Comment linking /pg/

    on “How PostgreSQL stores rows”
  12. samaysharma · 2018-05-01

    Submitted The Internals of Postgres – Concurrency Control as a story · 197 points

    HN discussion
  13. mulander · 2020-04-04
    > Every time an on-disk database page (4KB) needs to be modified by a write operation, even just a single byte, a copy of the entire page, edited with the requested changes, is written to the write-ahead log (WAL). Physical streaming replication leverages this existing WAL infrastructure as a log of changes it streams to replicas. First, the PostgreSQL page size is 8KB and has been that since the beginning. The rema…

    Comment linking /pg/pgsql09.html

    on “PostgreSQL's Imperfections”
  14. stevenmh · 2025-03-03

    Submitted The Internals of PostgreSQL as a story · 194 points

    HN discussion
  15. luhn · 2022-01-26
    The heap is described in 1.3 [1] and MVCC is described in Chapter 5 [2]. I'd also recommend the Postgres docs [3], they aren't quite as accessible as this but are detailed and overall well-written. [1] https://www.interdb.jp/pg/pgsql01.html#_1.3 . [2] https://www.interdb.jp/pg/pgsql05.html [3] https://www.postgresql.org/docs/14/internals.html

    Comment linking /pg/pgsql05.html

    on “The Internals of PostgreSQL”
  16. todsacerdoti · 2022-02-12

    Submitted The Internals of PostgreSQL: Chapter 3 Query Processing as a story · 26 points

    HN discussion
  17. Ostrogodsky · 2022-01-26
    The FAQ section is refreshingly and hilariously honest: https://www.interdb.jp/pg/faq.html

    Comment linking /pg/faq.html

    on “The Internals of PostgreSQL”
  18. enz · 2020-05-08

    Submitted The Internals of PostgreSQL as a story · 4 points

    HN discussion
  19. password4321 · 2022-02-17
    As recommended by multiple users last week: https://news.ycombinator.com/item?id=30279986#30281910 > I cannot recommend https://www.interdb.jp/pg/ enough, an excellent text with lots of details

    Comment linking /pg/

    on “The Internals of PostgreSQL”
  20. ptr · 2018-05-06

    Submitted The Internals of PostgreSQL as a story · 4 points

    HN discussion
  21. nerdyadventurer · 2022-08-27
    How is this different from https://www.interdb.jp/pg/index.html ?

    Comment linking /pg/index.html

    on “PostgreSQL 14 Internals book – Part II”
  22. myth17 · 2016-07-22

    Submitted The Internals of PostgreSQL as a story · 4 points

    HN discussion
  23. throwaway8941 · 2020-08-03
    http://www.interdb.jp/pg/ https://www.postgresql.org/docs/current/internals.html

    Comment linking /pg/

    on “PostgreSQL beginner guide”
  24. geuds · 2024-08-06

    Submitted The Engineer's Guide to Deep Learning as a story · 3 points

    HN discussion
  25. oftenwrong · 2020-06-14
    https://vladmihalcea.com/how-does-mvcc-multi-version-concurr... http://www.interdb.jp/pg/pgsql05.html

    Comment linking /pg/pgsql05.html

    on “Readings in Database Systems, 5th Edition (2015)”
  26. MarkusWinand · 2019-01-18

    Submitted Internals of PostgreSQL – Online book covering PostrgreSQL 11 as a story · 3 points

    HN discussion
  27. qazpot · 2018-05-02
    This is the best FAQ I have ever read - http://www.interdb.jp/pg/faq.html

    Comment linking /pg/faq.html

    on “The Internals of Postgres – Concurrency Control”
  28. ibobev · 2024-07-16

    Submitted The Internals of PostgreSQL as a story · 2 points

    HN discussion
  29. jodrellblank · 2025-03-03
    I won't comment on the OP using 'horrendous' as an adjective, but that quote seems misleading and unclear to me. Transactions (not transaction logs) are about maintaining [relational] database consistency, not directly about ensuring no data loss. A database engine would rather roll back a partially applied transaction and lose the data in it, than update one table and not update another, breaking the relation betwe…

    Comment linking /pg/pgsql09.html

    on “The Internals of PostgreSQL”
  30. BinaryIgor · 2026-03-07

    Submitted The Internals of PostgreSQL as a story · 1 points

    HN discussion

Search all of HN for interdb.jp

Linked by the same people?