[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-performance
Subject: [PERFORM] Performance degradation from PostgreSQL 8.2.21 to PostgreSQL 9.3.2
From: fx TATEISHI KOJI <koji.tateishi () fujixerox ! co ! jp>
Date: 2017-07-19 1:54:46
Message-ID: SINPR0601MB18068241DAFA4B059C7693BBB2A60 () SINPR0601MB1806 ! apcprd06 ! prod ! outlook ! com
[Download RAW message or body]
Issuing exactly the same query as PostgreSQL 8.2.21 and PostgreSQL 9.3.2 will slow the response by 6.4 ms on average.
What could be the cause?
Measurement method is as follows.
・瘢雹 PostgreSQL 8.2.21 installation
★Measurement
・瘢雹 Export DUMP of PostgreSQL 8.2.21
・瘢雹 PostgreSQL 8.2.21 uninstallation
・瘢雹 PostgreSQL 9.3.2 installation
・瘢雹 Dump import
★Measurement
[query]
select
table4.a as col_0_0_,
table4.a as col_1_0_,
table4.a as col_2_0_,
table4.b as col_0_1_,
table4.c,
table4.d
from
table1,
table2,
table3,
table4
where
table1.a=table2.a and
table1.a="parameter$1" and
table2.roleid=table3.roleid and
table3.a="parameter$2" and
table4.b='3' and
table2.a=table4.a;
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic