How wanglinn/postgres works
PostgreSQL is an object-relational database server. Its principal workflow accepts SQL through a client connection, executes queries, and returns results; the sampled portal code explicitly dispatches query execution to the executor. The README documents major capabilities, including transactions, foreign keys, subqueries, triggers, and user-defined types and functions. The graph preserves these product areas, plus storage, procedural languages, and replication. Many implementation paths are represented by their exact tree directories because their source was not sampled; links without direct evidence are dashed.
Main entry points: executor Query executor · parser SQL parsing · storage.c Relation storage · transam Transactions
Components 22
Query processing
- SQL parsing
src/backend/parser - Query rewriting
src/backend/rewrite/rewriteHandler.c - Query planning
src/backend/optimizer - Portal execution
src/backend/tcop/pquery.c - Query executor
src/backend/executor - Query fingerprinting
src/backend/nodes/queryjumblefuncs.c
Database engine
- Transactions
src/backend/access/transam - Heap tables
src/backend/access/heap - Index access methods
src/backend/access - Relation storage
src/backend/catalog/storage.c - System catalogs
src/backend/catalog - Core runtime interfaces
src/include
SQL capabilities
- Foreign keys
src/backend/commands/constraint.c - Triggers
src/backend/commands/trigger.c - User-defined types
src/backend/commands/typecmds.c - Ltree search types
contrib/ltree
Interfaces and extensions
- Client connections
src/backend/libpq - PL/pgSQL
src/pl/plpgsql/src/pl_handler.c - Foreign data wrapper
contrib/postgres_fdw - Logical replication
src/backend/replication/logical - Base backups
src/backend/backup
Other components
- SQL client
Connections 23
- SQL client → Client connections: connects
- Client connections → SQL parsing: submits SQL
- SQL parsing → Query rewriting: produces queries
- Query rewriting → Query planning: rewrites queries
- Query planning → Portal execution: plans statements
- Portal execution → Query executor: runs queries
src/backend/tcop/pquery.c - Query executor → SQL client: returns results
- Query executor → Heap tables: scans tables
- Query executor → Index access methods: uses indexes
- Query executor → Transactions: runs in
- Heap tables → Relation storage: uses storage
- Relation storage → Transactions: logs changes
- Query executor → Foreign keys: checks constraints
- Query executor → Triggers: fires triggers
- SQL parsing → User-defined types: resolves types
- Query executor → PL/pgSQL: calls functions
- Query executor → Foreign data wrapper: dispatches scans
- Transactions → Logical replication: supports changes
- Relation storage → Base backups: supplies files
- Query fingerprinting → Query executor: identifies queries
- SQL parsing → Ltree search types: exposes type syntax
- Core runtime interfaces → Relation storage: declares interfaces
src/include/catalog/storage.h - System catalogs → User-defined types: records definitions