App services

Postgres 16

Timescale 2.x extension

hypertables: alerts, deliveries
7d retention

regular tables: companies,
individuals, groups, fcm_tokens,
sources, subscriptions, bots

Redis 7

dedupe keys, TTL 60s

rate-limit token buckets

ClickHouse 24.x

alerts_archive

deliveries_archive

materialized aggregates
per-company, per-channel