How to Handle Hundreds of Millions of Aggregations Without Touching PostgreSQL — ClickHouse Sidecar and CDC Real-Time Sync

During early morning batch report runs, payment API response times spike by 2–3 seconds. The cause is straightforward: the orders and payments tables…