Hacker News Reader

And Redis has auto-delete rows (aka TTL). In Postgres you need a cron job to clear stale rows.

You can create an index on an expires_at column and opportunistically DELETE on each write to the cache table.

This is one way to handle the problem, but not the only...