What is the recommended (type) of database design for storing large amounts of time-series data?
- 2 million time-series;
- Each of the time-series contains around 500 timestamps;
- At each of the time-stamp there are multiple variables (meta-data);
- It would be optimal if meta-data could later easily be ingested into the database (preferably with a Python API) .
I have looked into PostgreSQL, but so far I have been struggling to set it up for many time-series.