Good heuristic to debug your slowed down app in production:
1️⃣: It's never Redis
2️⃣: It's always a Postgres missing index.
Conversation
This Tweet was deleted by the Tweet author. Learn more
Quote Tweet
Performance may still not be optimal (it's running on the cheapest OVH VPS), but it was interesting to find solutions to improve API response time.
I discovered interesting Postgres tricks related to index on date/time, in particular the CLUSTER function: dba.stackexchange.com/questions/2792
Show this thread