Presented by:

Bd8b79c88c8fa1364e0c3ac9b9fc0fe1

Hector Perez

European Space Agency
E20a31d9ceef2b55d84cf696e6544872

David Kohn

Timescale
No video of the event yet, sorry!
Download the Slides

The European Space Agency Solar Orbiter mission's objective is to perform close-up, high-resolution studies of our Sun and inner heliosphere, through a combination of in-situ and remote-sensing instruments. The products obtained will be stored within the Solar Orbiter Archive (SOAR). All the in-situ measurements have the form of time series products which will hold hundreds of millions values. Storing these values in a relational database could leverage the scientific exploitation of these measurements, allowing scientists to perform more accurate searches on the data, to restrict the retrieval to a specific time range, or to plot on-demand specific variables.

TimescaleDB is a PostgreSQL extension, which has been conceived to handle time series data in an optimized way. After performing a preliminary scalability study between Postgres 10 non partitioned, Postgres 10 built-in partitioning, and TimescaleDB, the latter has been chosen due to its comparable performance and scalability, as well as for its easiness of use. This talk will provide an overview about the time series use case for the Solar Orbiter mission and an insight on the benchmarks.

Date:
Duration:
50 min
Room:
Conference:
PostgresConf US 2018
Language:
English
Track:
Use Cases
Difficulty:
Medium