| Database Engine | Best Workload | 100M Query (p99) | Compression Ratio | Monthly Infra |
|---|---|---|---|---|
| PostgreSQL 17 | ACID Ledger | 4,150 ms | 1.9x | $420 / mo |
| ClickHouse 25 | Telemetry OLAP | 54 ms | 9.6x (ZSTD) | $290 / mo |
| DuckDB 1.2 | Local Parquet | 98 ms | 6.5x | $0 (Local CPU) |
import asyncio
from dataclasses import dataclass
@dataclass
class TelemetryBatch:
tenant: str
events: list[dict]
async def process_telemetry(batch: TelemetryBatch) -> dict:
await asyncio.sleep(0.005)
return {"tenant": batch.tenant, "processed": len(batch.events)}
Staging credentials ([API_KEY_REDACTED], [EMAIL_REDACTED]) for [REDACTED] were automatically redacted locally prior to export.