Alexander Ioffe: I ran the same query twice and Postgres disagreed with itself

2026-10-06来源 Planet PostgreSQLEnglish
Two EXPLAIN ANALYZE runs on statistically identical data produced opposite plans, 73 heap blocks against 3,449. The margin was 1.5%. Here's the mechanism, measured with ExoBench, and the index shape that takes the coin out of the planner's hand.

原文：https://www.a8q9.cn/en/article/alexander-ioffe-i-ran-the-same-query-twice-and-postgres-disagreed-with-itself-23f9f1.html

相关文章