If you use an UNLOGGED table in Postgres as a cache, and your DB restarts, you n...

frollogaston · 2025-09-26T03:24:42

Cache isn't meant to persist, and something is wrong if you hard depend on it persisting.

Spivak · 2025-09-26T02:53:04

Same as the folks who use in-memory Redis. Is there something uniquely bad about Postgres for this situation?

If your cache is so performance critical that you can't lose the data then it sounds like you need a (denormalized) database.

wielebny · 2025-09-26T03:57:41

If you need persistence on your Redis, then you're not using is as a cache. You're using it as a key-value store.

sgarland · 2025-09-26T15:17:56

Not quite - if you have a crash / hard restart, the table is truncated. If Postgres gracefully shuts down, the data is retained.

shakna · 2025-09-26T03:40:55

Cache is not the only solution to the thundering herd.