When Postgres is enough: replacing Redis for cache, queue and pub/sub
We removed Redis from a mid-sized SaaS stack and moved its cache, job queue and pub/sub into Postgres. Here is the schema we used, the limits we measured, the traps we hit, and the signals that tell you to bring Redis back.