Hello,
I am Jinho Jung, PhD student at Georgia Tech and I am conducting DB performance research. I am sending our evaluation result to get the feedback regarding our findings.
We found several performance regression queries. Attached files are three of them that we confirmed performance regression (in terms of query execution time) between v10.6 and v9.4.20. Hope you can test these queries and give us feedback. For your information, we are also sending the execution time measured on our machine.
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
20.sql
10.6 : 2791 ms
9.4.20: 61 ms
Evaluation setup
==============
2) without importing additional data, just run the attached queries
We appreciate you taking time for test!
Best regards,
Jinho Jung