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 ============== 1) compile 9.4.20 and 10.6 from released source code (https://www.postgresql.org/ftp/source/) 2) without importing additional data, just run the attached queries We appreciate you taking time for test! Best regards, Jinho Jung
1.sql
Description: 1.sql
4.sql
Description: 4.sql
20.sql
Description: 20.sql
