Re: Help needed to understand query planner regression with incremental sort

2023-06-01 Thread Henrik Peinar (nodeSWAT.com)
Thank you for taking the time to look this through. After reading your answer it obviously makes perfect sense, I was just thrown off by a fact that when it started happening, it happened on every query execution (for the same test query that I used). But I failed to think about trying different s

Re: Help needed to understand query planner regression with incremental sort

2023-05-31 Thread Tom Lane
"Henrik Peinar (nodeSWAT.com)" writes: > *Quick description: *After upgrading our Aurora PostgreSQL engine from v11 > to v15, one of our often run SQL's started taking tens of seconds instead > of running sub 100ms. Explain analyze showed that the query planner had > switched to using incremental

Help needed to understand query planner regression with incremental sort

2023-05-31 Thread Henrik Peinar (nodeSWAT.com)
*Quick description: *After upgrading our Aurora PostgreSQL engine from v11 to v15, one of our often run SQL's started taking tens of seconds instead of running sub 100ms. Explain analyze showed that the query planner had switched to using incremental sort. Running ANALYZE on the table fixed the iss