logo
Kurashizu Blogwhere ideas flow
  • Home
  • News
  • Blog
  • About
  • Home
  • News
  • Blog
  • About

© 2026 Kurashizu. All rights reserved.

Admin·New Post·Service Status
Powered by Cloudflare·01.11.26
← Back to news

PGSimCity - How PostgreSQL Works

Original article
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:

AttributeDetail
PurposeEducational Visualization
Commercial StatusNon-commercial
AffiliationNone

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 MMM and its accompanying explanations EEE can be represented as: Accuracy(M,E)≈Variable\text{Accuracy}(M, E) \approx \text{Variable}Accuracy(M,E)≈Variable

In other words, it almost certainly contains inaccuracies in both the model and the provided explanations.

PGSimCity Concept