Our great sponsors
-
TimescaleDB
An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
-
python-fake-data-producer-for-apache-kafka
The Python fake data producer for Apache Kafka® is a complete demo app allowing you to quickly produce JSON fake streaming datasets and push it to an Apache Kafka topic.
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
Don't forget PostgreSQL extensions. For something like a chat log, TimescaleDB (https://www.timescale.com/) can be surprisingly efficient. It will handle partitioning for you, with additional features like data reordering, compression, and retention policies.
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?
- Do we have such a thing as Postgres Atlas?
- 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?