Hi, On 2018/11/20 2:49, Jung, Jinho wrote: > Execution time > ============= > 1.sql > 10.6 : 469 ms > 9.4.20: 10 ms > > 4.sql > 10.6 : 34019 ms > 9.4.20: 0.4 ms
I noticed that these two are fixed by running ANALYZE in the database in which these queries are run. > 20.sql > 10.6 : 2791 ms > 9.4.20: 61 ms This one may be suffering from a more serious planning issue, as doing ANALYZE didn't help for this one. Will have to look closely at how the plan is changing for worse. Thanks, Amit
