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.
Cache invalidation on Redis is setting a TTL of 60s on the kv I just set, in a single atomic operation.
Cache invalidation on Redis is setting a TTL of 60s on the kv I just set, in a single atomic operation.