clickhouse migrations pay off fastest when events are append heavy and dashboards are wide scans. keeping postgres for writes + clickhouse for reads is usually the clean middle ground.