> also most cache at least support a ttl which might be even worse for postgres on the query side since it needs to evaluate the expiration date on the client s

> also most cache at least support a ttl which might be even worse for postgres on the query side since it needs to evaluate the expiration date on the client side while redis supports that directly. Afaik redis will check TTLs on access as well as in a background process, so postgres isn't really behind on this one.