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
