From: | Осипков Андрей Сергеевич <osipkovas(at)mosreg(dot)ru> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | The performance on 9.6.3 for our query differs by more than 10 times than at 9.5.7. |
Date: | 2017-07-25 14:55:32 |
Message-ID: | 91f45404-30ae-7601-705f-8272acd9f493@mosreg.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Good afternoon!
Our environment:
Version: postgres 9.6.3
Operating system: Linux andrey-pc 4.4.0-72-generic # 93-Ubuntu SMP Fri
Mar 31 14:07:41 UTC 2017 x86_64 x86_64 x86_64 GNU / Linux
Processor: Intel (R) Core (TM) i7-5600U CPU @ 2.60GHz
Memory: 7872MiB
We have a problem:
The performance on 9.6.3 for our query differs by more than 10 times
than at 9.5.7.
9.5.7 - run time - 4 seconds
9.6.3 - run time - 51 seconds
9.6.3 - when using the enable_nestloop = off - 3 seconds
Attachment files:
base.sql.zip - dump the required tables (200 MiB) - link download_dump
<https://drive.google.com/file/d/0B_jqtQpaEJr2WjBUbXlscXNsdVU/view?usp=sharing>
request.sql - our request
result_request.csv - result of our request
Regards Andrew Osipkov.
Attachment | Content-Type | Size |
---|---|---|
request.sql | application/sql | 1.2 KB |
result_request.csv | text/csv | 35.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Vincas Dargis | 2017-07-25 15:52:02 | Re: BUG #14761: pg_dumpall --version is misleading (from jessie-pgdg postgresql-client-common) |
Previous Message | Tom Lane | 2017-07-25 14:47:20 | Re: BUG #14761: pg_dumpall --version is misleading (from jessie-pgdg postgresql-client-common) |