Change chunk size in metrics-psqlts-01 DB
I have found out that timescaledb uses as standard chuck size 1 day (https://www.timescale.com/blog/timescale-cloud-tips-testing-your-chunk-size/). I think we are using too much memory at the moment with the current size (https://grafana.torproject.org/d/Z7T7Cfemz/node-exporter-full?orgId=1&viewPanel=156&var-job=node&var-node=metrics-psqlts-01.torproject.org&var-port=9100&from=1664812800000&to=now). I suggest we try out 7 days instead and see how that goes.
In order to do this we should drop the current hypertable and set the correct chunk size. Also it's better if this is set in our sql files too in case the DB has to be recreated.
Edited by Hiro