Supertoast tables
Summary
A technical post describing Hatchet's approach to preventing large jsonb payloads from bloating Postgres by migrating to supertoast tables. It covers why jsonb is used, the downsides of large payloads, the concept of hot vs. cold storage with S3 offloads, and a write-and-swap partition strategy to reduce autovacuum pressure and costs.