TECHNOLOGY

PostgreSQL

PostgreSQL is a powerful, open-source object-relational database management system known for enterprise reliability, feature robustness, extensible data types, and ACID compliance.

Initial Release: July 8, 1996
Original Creator: Michael Stonebraker (POSTGRES Project, UC Berkeley 1986)
Developer: PostgreSQL Global Development Group

TECHNOLOGYPostgreSQL

Trails Articles

Quick facts

At a glance

Initial Release: July 8, 1996
Origins: UC Berkeley POSTGRES (1986)
Lead Architect: Michael Stonebraker
Type: Object-Relational DBMS
License: PostgreSQL Open Source License

Overview

Architecture & Durability

PostgreSQL traces its roots to the POSTGRES project started at the University of California, Berkeley in 1986 under the leadership of Professor Michael Stonebraker. In 1994, Andrew Yu and Jolly Chen added an SQL query language interpreter, creating Postgres95, which was subsequently renamed PostgreSQL in 1996 to reflect its SQL standard capabilities.

PostgreSQL is engineered around Multi-Version Concurrency Control (MVCC), which eliminates read-write table lock contention by keeping snapshot records of row modifications. Its modular architecture permits in-database extensions such as PostGIS for spatial data, pgvector for AI embedding similarity searches, and native binary JSONB for document storage.

Architecture Evolution

Chronology

1986
POSTGRES Project Begins
Stonebraker leads next-generation database research at UC Berkeley.
1996
PostgreSQL 6.0 Released
Open source community adopts standard SQL support.
2005
Version 8.0 & Point-in-Time Recovery
Native Windows support and write-ahead log recovery.
2014
PostgreSQL 9.4 (JSONB)
Introduced indexed binary JSON, combining relational and document schemas.
2023
PostgreSQL 16
Enhanced logical replication, parallel query planning, and I/O monitoring.