Perfomance 9.1.9 vs 9.4.1

From: Alexander Uspensky <al(dot)v(dot)uspensky(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Perfomance 9.1.9 vs 9.4.1
Date: 2015-03-15 08:51:13
Message-ID: CAJSSGvKt1aWNK3_3FOPKDYoXYwbRxf_0W5q2oHOAzrHmMTw61Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dear,

I am comparing 9.1.9 and 9.4.1. I think that perfomance of 9.4.1 should be
better.
But I have an issue here.
I have installed both db on the same machine and I have 2 results,
where I see that for some reason 9.1.9 works faster - 118ms vs 452ms.
I checked the same sql query (a complex view) with EXPLAIN ANALYZE (with
the same work_mem and shared_buffres).
Could you please help me what should I do?

1) 9.1.9
Limit (cost=6435.41..6435.41 rows=1 width=10) (actual
time=118.720..118.723 rows=25 loops=1)
-> Sort (cost=6435.41..6435.41 rows=1 width=10) (actual
time=118.719..118.720 rows=25 loops=1)
...
Total runtime: 118.921 ms
(48 rows)

2) 9.4.1
Limit (cost=507.65..507.66 rows=1 width=10) (actual time=452.124..452.127
rows=25 loops=1)
-> Sort (cost=507.65..507.66 rows=1 width=10) (actual
time=451.760..451.760 rows=25 loops=1)
...
Planning time: 3.406 ms
Execution time: 452.297 ms
(51 rows)

--
Best regards, Alexander

Browse pgsql-sql by date

  From Date Subject
Next Message Alexander Uspensky 2015-03-15 09:50:10 Perfomance 9.1.9 vs 9.4.1
Previous Message bricklen 2015-03-14 14:20:54 Re: Strange Query - Reg