The performance on 9.6.3 for our query differs by more than 10 times than at 9.5.7.

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

Browse pgsql-bugs by date

  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)