Interesting reading!

Did you try using purposely-built time series database additionally to or instead of PinalyticsDB? There are many good choices with various pros and cons out there — InfluxDB, TimescaleDB, M3DB, Cortex or VictoriaMetrics. There is also ClickHouse, which also can be used for time series workloads.

Specialized databases usually have lower operational costs comparing to general-purpose solutions, since they require less CPU, RAM, disk space and network bandwidth.