PostgreSQL is a well-designed, open-source multi-purpose relational database system which is widely used throughout the world. It is one huge system with the integrated subsystems, each of which has a particular complex feature and works cooperatively with each other. Although understanding of the internal mechanism is crucial for both administration and integration using PostgreSQL, its hugeness and complexity make it difficult. The main purposes of this document are to explain how each subsystem works, and to provide the whole picture of PostgreSQL.

This document covers versions 16 and earlier.

Some academic papers have referred to this document. The Chinese version of this document was published in June 2019.

Guide map
Change History

Click here to show the change history since 3rd June, 2018.


Hironobu SUZUKI

I graduated from graduate school in information engineering (M.S. in Information Engineering), have worked for several companies as a software developer and technical manager/director. I published seven books in the fields of database and system integration (4 PostgreSQL books and 3 MySQL books). In June 2019, the Chinese book of this document was published.

As a director of the Japan PostgreSQL Users Group (2010-2016), I organized the largest (non-commercial) technical seminar/lecture on PostgreSQL in Japan for more than six years, and also served as the program committee chair of the Japan PostgreSQL Conference in 2013 and as a member in 2008 and 2009.

In 2021, I released pg_plan_inspector that is a framework to monitor and improve the performance of PostgreSQL using Machine Learning methods.

In June 2022, my interview article was published in "PostgreSQL person of the week".

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

I am considering looking for a new job.
I love Swiss, however, I would like to do new challenges, e.g. applying ML and AI technologies to DBMS. I am waiting for contacts from people who want to do new things.



Please read this FAQ before sending messages.

After reading, send a message to my twitter in public.  


© Copyright ALL Right Reserved, Hironobu SUZUKI.

If you want to use any part of this document and/or any figure, please contact me. If you work at Amazon, you cannot use and refer to this document because of the copyright violation issues.
Exception: Educational institutions can use this document freely.