Running:
SELECT count(*) AS exact_count FROM hits;
We see:
With 30M Rows. This query takes 244 seconds. ⏳
Running this query for each hit badge was crashing the server. 💔
But with the hit_count table in place, it's now not a burning issue 🔥 😥
priority-2 because the aggregation isn't crashing the server anymore and we can fix this with time. 🧑💻 🔍
Starting point: https://stackoverflow.com/questions/55018986/postgresql-select-count-query-takes-long-time
Running:
We see:
With
30M Rows. This query takes 244 seconds. ⏳Running this query for each
hitbadge was crashing the server. 💔But with the
hit_counttable in place, it's now not a burning issue 🔥 😥priority-2because the aggregation isn't crashing the server anymore and we can fix this with time. 🧑💻 🔍Starting point: https://stackoverflow.com/questions/55018986/postgresql-select-count-query-takes-long-time