| 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: | Whole Thread | Raw Message | 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) |