Andrei Lepikhov: 500 Milliseconds on Planning: How PostgreSQL Statistics Slowed Down a Query 20 Times Over
📝
内容提要
A query executes in just 2 milliseconds, yet its planning phase takes 500 ms. The database is reasonably sized, the query involves 9 tables, and the default_statistics_target is set to only 500....
🏷️
标签
➡️
