Command ID Visibility in PostgreSQL Extensions: What Apache AGE Taught Us
Two bugs in Apache AGE — the graph database extension for PostgreSQL — exposed a subtle interaction between PostgreSQL's Multi-Version Concurrency Control (MVCC) visibility rules and how extensions manage Command IDs inside custom executor nodes. This post walks through the internals involved, explains both bugs and their fixes, and extracts