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

2023-06-01 Thread Henrik Peinar (nodeSWAT.com)
ng for the fields inside composite indexes I think, so that's why they appear the same. Very much appreciated of your time. With best, Henrik. On Wed, May 31, 2023 at 6:31 PM Tom Lane wrote: > "Henrik Peinar (nodeSWAT.com)" writes: > > *Quick description: *After upgr

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