For OLAP workloads exceeding 1TB of denormalized event data, PostgreSQL 17 delivers 42% higher aggregate scan throughput than MongoDB 8.0 and 2.1x faster than Cassandra 5.0 on AWS i4i.2xlarge instances, but only if you configure it correctly.

📡 Hacker News Top Stories Right Now

The text mode lie: why modern TUIs are a nightmare for accessibility (85 points)

Let's Buy Spirit Air (85 points)

Agentic Coding Is a Trap (107 points)

BYOMesh – New LoRa mesh radio offers 100x the bandwidth (249 points)

DeepClaude – Claude Code agent loop with DeepSeek V4 Pro, 17x cheaper (156 points)

Key Insights

PostgreSQL 17 achieves 1.8M rows/sec scan throughput for 1TB flat fact tables on i4i.2xlarge, 42% higher than MongoDB 8.0’s 1.27M rows/sec (benchmark methodology: pgbench custom OLAP workload, 16 vCPU, 128GB RAM, 2x 3.8TB NVMe SSD)

MongoDB 8.0 reduces OLAP query latency by 37% vs MongoDB 7.0 via clustered collection improvements, but trails PostgreSQL 17 by 28% for ad-hoc aggregation pipelines

Cassandra 5.0…