Our great sponsors
-
TimescaleDB
An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
TimescaleDB is Postgres with extensions to automatically partition tables for fast processing of time series data.
-
TickTockDB is a new open-src TSDB. Although it is not rich in features, its write throughput can reach 3.2M data points/sec v.s. InfluxDB 74K in a 2c4g x86 (detail report here). It is enough for your case (79M data point/day = 914/sec). You may also have to consider max cardinality (i.e., number of time series supported) of TSDB. TickTockDB's max cardinality is 2M v.s. InfluxDB 150k in RaspberryPI4 (detail report here)).
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
Related posts
- TimescaleDB: An open-source time-series SQL database
- How to setup Postgres master-master cluster.
- Why does the presence of a large write-only table in a PostgreSQL database cause severe performance degradation?
- I have to do about a million inserts on a table every day that is also under very frequent reads. How should I do that?
- Postgres for time-series data