PGSimCity - How PostgreSQL Works
nikolays.github.io|840 points|82 comments|by jonbaer|Jul 27, 2026
PGSimCity: Visualizing the PostgreSQL Engine
PGSimCity is an independent and non-commercial educational project designed to provide a 3D visualization of the internal workings of PostgreSQL.
Project Overview
The goal is to create a functional model of the database engine. The conceptual flow is as follows:
| Attribute | Detail |
|---|---|
| Purpose | Educational Visualization |
| Commercial Status | Non-commercial |
| Affiliation | None |
Legal Disclaimer
This project is not affiliated with, sponsored by, endorsed, or approved by Electronic Arts Inc.
Current Development Status
The project is currently in a state of early development:
- Initial 3D model construction
- Final technical review
- Accuracy verification
The system is currently executing the following process:
loading the city code...
Because this is an absolute early, unreviewed prototype, the model and its accompanying explanations can be represented as:
In other words, it almost certainly contains inaccuracies in both the model and the provided explanations.