Evaluation of the TimescaleDB PostgreSQL Time Series extension

The purpose of this project was to evaluate TimeScaleDB, an Open Source PostgreSQL extension which extends the functionality of the PostgreSQL database for hosting Time Series data in an optimum way while maintaining 100 % compatibility with the SQL standard and native PostgreSQL features such as replication. Early results of the solution look very promising compared to alternatives like InfluxDB (currently used at CERN) with a considerable improvement in the use of resources under heavy activity loads while additional benefiting of transparently integrating with currently offered CERN IT solutions. The technical core of the project would consist on deploying a setup capable of hosting the an activ- ity load equivalent to current CERN Time Series use cases using TimescaleDB to better understand its feature set and resource requirements.