Timeseries DB built as an extension to PosgreSQL
Pros
- Familiar relational DB
- Conformant SQL query language
- Compatible with all existing tooling for relational DBs
- Columnar store : higher performance than PostgreSQL for timeseries data
Cons
- Less performant than dedicated OLAP
- Limited options for managed DB (Timescale Cloud)
Installation
https://blog.timescale.com/tutorials/tutorial-installing-timescaledb-on-aws-c8602b767a98/
- Imm/ r⁴
https://www.dnsfilter.com/blog/timescaledb-performance/
https://www.pradeepchhetri.xyz/clickhousevstimescaledb/#conclusion