I added a grid_size column. Two months later I dropped it. What I learned about derived state in Postgres.

TL;DR: a grid_size INT column on three tables (rooms, players, card_templates) looked like a sane denormalization for a multiplayer bingo game. Two months later I deleted it on all three tables, because the value is tautologically encoded in another column already in those rows. Derived state at rea