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