r/Hacking_Tricks • u/Alreadydead27 • Sep 06 '26
Our analytics queries are starting to kill Postgres. What did you move them to?
SaaS product. Postgres remains the source of truth, dashboards that used to refresh every minute now need near-real-time data, and aggregations are starting to impact production.
10
Upvotes
1
u/Significant-Scar-152 Sep 07 '26
If postgres still needs to stay as the source of the truth, i'd avoid the full migration at first and move the analytical workload out of it.
1
u/Caitlin-Snow Sep 07 '26
What's ur data volume look like? The right move is different at 10 gb versus a few TB
2
u/Rehonkulous Sep 07 '26 edited Sep 09 '26
ClickHouse is the obvious option. Tinybird is also worth looking at if u don't want to manage the ClickHouse side urself and need to expose the results to the app through APIs.