[deepsun]

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

[samuelknight]

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

[pooloo]

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