Full disclaimer - Timescale person here - but your use case seems like an example of what a time-series database is for, and given that TimescaleDB[0] is implem

Full disclaimer - Timescale person here - but your use case seems like an example of what a time-series database is for, and given that TimescaleDB[0] is implemented as an extension to Postgres, it's a real obvious fit. It's designed around the idea of time-series data. It should give you better insert and query performance since it's geared towards that workload. Aside from that, you could even reap the storage benefits using native compression that it supports. [0] https://www.timescale.com/ https://www.timescale.com/