From SQL to disk in Postgres
A practical, surface-level tour of what PostgreSQL writes to disk when you run SQL—OIDs, relfilenodes, heap segments, and 8KB pages—plus how to peek at the raw files.
A practical, surface-level tour of what PostgreSQL writes to disk when you run SQL—OIDs, relfilenodes, heap segments, and 8KB pages—plus how to peek at the raw files.