Alexander Ioffe: Why is my Whale Query 1000x Slower in Prod? Databases hate skew, each hates it differently

2026-10-13来源 Planet PostgreSQLEnglish
Ten enterprise customers own 80% of the orders. On uniform test data the query runs in ~1ms; on that real skew it runs ~1,000x slower. The fix doesn't transfer between engines: Postgres is rescued by one free session setting, SQL Server can't be touched by it and needs a completely different access-path fix. Measured on Neon and Azure SQL Database using ExoBench.

原文：https://www.a8q9.cn/en/article/alexander-ioffe-why-is-my-whale-query-1000x-slower-in-prod-databases-hate-skew-e-ed0c16.html

相关文章