[sgarland]

Those examples are all equally difficult to reason about. Cache invalidation is equivalent to refreshing a materialized view, and UNLOGGED tables bring about new and exciting ways lose data.

[fastball]

Cache invalidation on Redis is setting a TTL of 60s on the kv I just set, in a single atomic operation.

[mindwok]

You can also pg_cron refresh a materialised view every minute which seems similar.