What is the best way to cache postgresql data?

Question

PHP

Good day!
A database is given in which static content is located, which must be given to each user who logged into the account.
The question is how to ensure the maximum speed and availability of this data? Does it make sense to use Redis as a layer, or is psql enough?
The main goal: the fastest possible reading of the same data for many users.

Answer 1

If the data is read frequently, then it will definitely be in the postgres buffer. If you have static content that you simply fetch by key, then there will be almost no difference with Redis, the connection takes longer than the data fetch.

Answer 2

For novice programmers, caching is a kind of fetish. And they try to shove it anywhere, for no reason at all. Or rather, the reason is their own fears generated by ignorance