The Internals of PostgreSQL

by Mira Azkia 03 November 2026 5 min read 101x views

I am officially open to new global opportunities! 🌍

After a impermanent remain in Japan to concentration on my health and individual responsibilities, I am completely recovered, ready, and enthusiastic to activity abroad again.

I am extremely curious in returning to Europe, as fine as opportunities in the Southern Hemisphere and Southeast Asia.

Looking for:

Challenging tasks in PostgreSQL.
Roles offering global visa sponsorship OR Remote activity that supports a digital nomad lifestyle.

If your squad is hiring, let’s connect! Please awareness liberated to attain out via e-Mail(hironobu @ interdb.jp or interdb.mx @ gmail.com) or DM.

What’s New

26 Sep 2026: 11th Anniversary! This satisfied was launched on 26 September 2015.
28 Jun 2026: Section 8.5, “Asynchronous I/O in PostgreSQL” Published.
1 May 2026: Chapter 12, “Logical Replication” (Beta Version) Published.
14 Dec 2024: Added Conflicts in Section 11.2.4.

Change History (since 3rd June, 2018)

The Internals of PostgreSQL

PostgreSQL is a well-designed, open-source multi-purpose relational repository scheme which is extensively used throughout the world.

It is one huge scheme alongside the unified subsystems, all of which has a particular complex characteristic and plant cooperatively alongside all other. Although understanding of the inner scheme is crucial for the two administration and integration using PostgreSQL, its hugeness and complexity create it difficult.

The chief purposes of this records are to explain how all subsystem works, and to provision the entire image of PostgreSQL.

This records covers versions 19-beta (excluding the new buffer leaf fastener mechanism) and earlier.

Some scholarly papers have referred to this documentation. The Chinese version of this records was published in June 2019.

This records was archetypal published on 26 September 2015.

Author

Hironobu SUZUKI

I am a application programmer/engineer, the author of:

I graduated from alumnus academy in data engineering (M.S. in Information Engineering), have worked for multiple companies as a application developer and specialized manager/director. I published seven books in the sectors of repository and scheme integration (4 PostgreSQL books and 3 MySQL books). In June 2019, the Chinese publish of this records was published.

As a director of the Japan PostgreSQL Users Group (2010-2016), I organized the largest (non-commercial) specialized seminar/lecture on PostgreSQL in Japan for additional than six years, and additionally served as the program commission place of the Japan PostgreSQL Conference in 2013 and as a associate in 2008 and 2009.

In June 2022, my discussion article was published in “PostgreSQL individual of the week”.

Cuando era joven, vivió en Sudamérica por unos años. Recientemente, a veces vuelve a allí.

I am seeking a distant stance focused on the use of ML and AI technologies to DBMS. For individual reasons, I volition be living in Japan for multiple years.

Blog

Contact

Please peruse the following FAQ before sending messages.

FAQ

Since publishing my content, I’ve been fortunate to obtain a lot of affirmative feedback, which is really gratifying. However, unfortunately, I’ve encountered individuals in the former who tried to misuse my satisfied for self-promotion ¹.

These experiences have shaped the method I’ve outlined below.

Who can use this records freely?
If you are a instructor or a pupil belonging to an instructional organization, you can openly use this records and figures in your study. Anyone can use this records and figures alongside noncommercial meetings and lectures, if you province the nexus to this location and the copyright; otherwise, communication me.
Is it accessible for business contents?
This satisfied can be used under two options:
There was a comment on Hacker News that took this seriously, but of course, it’s a joke. To be clear, I have no aim of having any business ties to this. Regardless, you can ideate the benevolent of requests I get on a regular basis.
- Revenue Share: You can leverage this satisfied following a income portion accord is signed. Under this agreement, you’ll portion 20% of the revenue generated from using this content.
- Full Buyout: In extremely rare cases, I regard requests for complete business use of all satisfied on this site. For a complete buyout of all satisfied rights, the disbursal is €5,000,000.
Does the author need any assistance to write?
No. I am penning for my own enjoyment. Even if you dispatch me your article, I volition never contain it in my documentation.
Why doesn’t the author use the GitBook or another e-book formats/sites?
I am using the finest tools I need and I volition decide what I use. I am continually trying a lot of tools for improved explanations.
Simply put, this records is optimized to peruse on html document and it is difficult to change to another formats.
I do not have any scheme to create PDF type and Smartphone versions since of identical reason.
Why doesn’t the author use RSS to notify the update?
I keep my domain and my server to provision my documentation; you can peruse whenever you desire to read. What do you desire more?
Why doesn’t the author waive the copyright of this records or use the imaginative commons license?
I’d akin to ask you what problems you have by that I keep on having the copyright of my documentation.

After reading, dispatch a communication to my twitter in public.

If you use email, delight provide at smallest two SNS addresses (e.g. LinkedIn, Twitter) for verification purposes. Due to the XZ backdoor incident, I no longer obtain communication from anonymous individuals.