cid 73c66f3453778aa74f892b09ba188f9c8dcfe5fa3faa95972d956c740a21b7bd · original · open access · via openalex
Title: Evaluation of the TimescaleDB PostgreSQL Time Series extension Authors: Elena Štefancová Venue: CERN Document Server (European Organization for Nuclear Research) Year: 2018 Canonical: openalex:https://openalex.org/W3128344176 URL: https://openalex.org/W3128344176 Collector: openalex OA: true ABSTRACT 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.