these are not happy graphs...
disk % used (with like 200+ GB each..)
https://stats.pixie.town/d/stats/node-stats?viewPanel=4&orgId=1&from=now-3h&to=now&var-job=terra
disk read/writes..
https://stats.pixie.town/d/stats/node-stats?viewPanel=32&orgId=1&from=now-3h&to=now&var-job=terra
REINDEX has been going for 50 minutes now
seems were up and running again!
https://stats.pixie.town/d/stats/node-stats?viewPanel=4&orgId=1&from=now-4h&to=now&var-job=terra
@f0x nice one!
holy shit was it worth it though
state_groups_state from:
2.80 * 10^8 row count, 42GB (table) + 22GB (index) = 64GB
to:
3.36 * 10*7 row count, 15GB (table) + 7208MB (index) = 15GB (wtf)