TimescaleDB

Time series databases are built specifically for this kind of workload.

TimescaleDB is an open-source database from Tiger data that adds time series capabilities to PostgreSQL.

It's implemented as a Postgres extension, so it introduces new functionality while preserving standard Postgres behavior and SQL.

This lets a single Postgres-based system handle both transactional and analytical workloads without splitting data across multiple tools.

And I think really the, the difference in the value of Postgres with its extensibility.

I used PostGIS for years, and I've been amazed at what you could do, accomplish from a GIS perspective.

And now in TimescaleDB is using those same concepts with the extensibility of Postgres, and the ability to interact from a query planner, automatically route to the appropriate request against the right chunks.

And we've spent a lot of time optimizing that path as well, so you touch as few chunks as possible for your queries, and so you can have a lot of historical data.