I'd look at setting up a true time-series database with something like Timescale with Postgres. @michael.flagler wrote up a great guide here: Historian using TimescaleDB w/ Postgres - #2 by michael.flagler
I'd look at setting up a true time-series database with something like Timescale with Postgres. @michael.flagler wrote up a great guide here: Historian using TimescaleDB w/ Postgres - #2 by michael.flagler