PG Phriday: Burnt TOAST
Summary
Shaun Thomas dives into PostgreSQL TOAST, explaining how oversized attributes are stored externally and the performance implications of toasted versus non-toasted data. The article walks through concrete experiments with an event_log table, compares storage sizes and read/write costs, and presents a schema redesign to relocate large columns for better page density, along with compression options and practical guidance.