Back to Resources

PostgreSQL Technical Materials

In-depth analysis of PostgreSQL architecture and performance

Theoretical Resources

Serializable Snapshot Isolation in PostgreSQL
Dan R. K. Ports et al., 2012 Beginner
4.0
Comprehensive benchmark evaluating the effectiveness of join ordering in modern optimizers using complex real-world queries.
Download PDF
The Internals of PostgreSQL
Hironobu SUZUKI, 2024 Beginner
5.0
The main purposes of this book are to explain how each subsystem works, and to provide the whole picture of PostgreSQL.
View Book
PostgreSQL 14 Internals
Egor Rogov, 2022 Beginner
5.0
This book is for those who will not settle for a black-box approach when working with a database. If you are eager to learn, prefer not to take expert advice for granted, and would like to figure out everything yourself, follow along.
View Book
Greenplum: A Hybrid Database for Transactional and Analytical Workloads
ZHENGHUA LYU, 2021 Intermediate
5.0
In this paper, we augment Greenplum into a hybrid system to serve both OLTP and OLAP workloads. The challenge we address here is to achieve this goal while maintaining the ACID properties with minimal performance overhead.
Download PDF

Practical Resources

How Good Are Query Optimizers, Really?
Leis et al., 2015 Beginner
5.0
Comprehensive benchmark evaluating the effectiveness of join ordering in modern optimizers using complex real-world queries.
Download PDF
Inner Join Query Performance: MariaDB vs PostgreSQL
U Hairah et al., 2021 Beginner
5.0
This study aims to provide a comparative analysis of the response time performance of MariaDB and PostgreSQL databases in the use of inner join queries.
Download PDF
Looking Back at Postgres
Joseph M. Hellerstein, 2019 Beginner
5.0
This is a recollection of the UC Berkeley Postgres project, which wasled by Mike Stonebraker from the mid-1980'sto the mid-1990's. The article wassolicited for Stonebraker's TuringAward book, as one of many personal/historical recollections.
Download PDF