Re: 9.5alpha1 vs 9.4

From: Andres Freund <andres(at)anarazel(dot)de>
To: "Mkrtchyan, Tigran" <tigran(dot)mkrtchyan(at)desy(dot)de>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: 9.5alpha1 vs 9.4
Date: 2015-07-05 12:54:03
Message-ID: 20150705125403.GD24494@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

On 2015-07-05 13:10:51 +0200, Mkrtchyan, Tigran wrote:
> today I have update my test system to 9.5alpha1.
> Most of the operations are ok, except delete.
> I get ~1000 times slower!

> 255.88 | 566.11 | 452 | DELETE FROM t_inodes WHERE ipnfsid=$1 AND inlink = ?

That certainly should not be the case. Could you show the query plan for
this statement in both versions? Any chance that there's a parameter
type mismatch for $1?

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2015-07-05 14:33:25 Re: 9.5alpha1 vs 9.4
Previous Message Mkrtchyan, Tigran 2015-07-05 11:46:08 Re: 9.5alpha1 vs 9.4