Performance regression related to parallel execution

2019-03-11 Thread Jinho Jung
Hello, We noticed that the following SQL queries are running 3 times slower on the latest version of PostgreSQL. Here’s the time taken to execute them on older (v9.5.16) and newer versions (v11.2) of PostgreSQL (in milliseconds): +---++-+-+---+

Performance regressions found using sqlfuzz

2019-03-06 Thread Jinho Jung
the same setup that we described before: https://www.postgresql.org/message-id/BN6PR07MB3409922471073F2B619A8CA4EE640%40BN6PR07MB3409.namprd07.prod.outlook.com - As Andrew mentioned before, we increased default work_mem to 128MB Best regards, Jinho Jung QUERY 5 EXPLAIN ANALYZE select ref_0