3 ms·
Hi, it's very interesting! Do you test if TimescaleDB affect the performances of the relational part of Postgres ? In other words, can I use TimescaleDB as my
by z0mbie42 8y ago
Hi, it's very interesting!
Do you test if TimescaleDB affect the performances of the relational part of Postgres ?
In other words, can I use TimescaleDB as my primary DB to store both my users and time series data ?
- mfreed 8y agoWe have not observed any effects on relational table performance. Basically, TimescaleDB code in on-path for each parsed query, but if the query does not specify a hypertable, we just let the query "fall through" to Postgres' standard query planning/execution. But you do point out a very common use case and strength of TimescaleDB: you can easily JOIN your time-series data (hypertables) with existing relational tables.