BUG #14675: Perfomance Issue after Upgrading from 9.5.3 to 9.6.3

From: walpino(at)gmx(dot)ch
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14675: Perfomance Issue after Upgrading from 9.5.3 to 9.6.3
Date: 2017-05-29 14:46:58
Message-ID: 20170529144658.4276.83573@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14675
Logged by: Martin Walpen
Email address: walpino(at)gmx(dot)ch
PostgreSQL version: 9.6.3
Operating system: CentOS Linux release 7.3.1611
Description:

Hello

we wanna upgrade our Installations from Version 9.5.3 to 9.6.3

everything works fine with the pg_upgrade

after the Upgrade process we encountered an performance issue

we have a join in a select statement

simply said, it looks like

select....
from
where column_a = coalesce(col_b, coalesce(col_c, col_b))

this was fast on 9.5.3
but now on 9.6.3 is is slow really really slow

the explain plan looks similar and not big difference

when I changed this query to

select....
from
where column_a = coalesce(col_b, col_c, col_b)

which should be the same

it was as fast as on 9.5.3

do you have any explanation for that?

thanks

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message marko 2017-05-29 15:38:47 BUG #14676: neqsel is NULL dumb
Previous Message fabriciorsf 2017-05-29 13:11:01 BUG #14674: Error on install portgresql