@dansup @pixelfed initially just let your DB handle caching for those situations, it is made for it. Of course that does require proper queries and decent indexes. PostgreSQL is great for that reason as it has the analysis/explains where one can update things. Adding a redis etc, is side cache, allowing your DB to cache more can be more than enough. Less moving parts, less cache inconsistencies.