ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Guide to pick the right MergeTree engine (plain, replicated, aggregating, collapsing) based on replication, aggregation, and update‑handling needs for time‑series data.
Compaction strategy is a data-lifecycle decision, not a tuning knob. How TWCS windows work for time-series, where out-of-order writes break them, and how to verify.
A task guide to PostgreSQL declarative range partitioning for time-series tables: choosing a key, creating monthly partitions, verifying partition pruning with EXPLAIN, and safely retiring or re-attaching partitions.
Learn how to implement and manage InfluxDB Retention Policies to automate data expiration, control disk usage, and balance historical data needs against storage costs.
Learn how to set up declarative range partitioning in PostgreSQL 10+ for time‑series data, balance monthly partitions, verify pruning, and safely drop old data.
Learn how to set up a ClickHouse TTL expression, verify part expiration, and avoid common pitfalls when automating time‑series data expiration.
How to set up InfluxDB 1.x continuous queries to automatically downsample raw metrics into a long-retention measurement, with verification steps, known pitfalls like missed late data, and how to safely modify or remove them.
Tags are indexed, fields are not — and that one fact decides whether your InfluxDB instance scales or runs out of memory. A practical guide to the tags-vs-fields decision and series cardinality.
Use PostgreSQL declarative RANGE partitioning on a timestamp with constraint exclusion pruning to cut I/O for time-series queries, while accepting per-partition vacuum and planner requirements.
clickhouse
cassandra
influxdb