t consider changing it if we have no other choice...
Regards,
Kevin
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Dienstag, 31. März 2015 15:59
To: Kevin Viraud
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Weird CASE WHEN behaviour causing query to b
don’t have the control over this one and that I’m using it as if.
This is only my debugging query.
Best regards,
Kevin
From: Pavel Stehule [mailto:pavel.steh...@gmail.com]
Sent: Dienstag, 31. März 2015 11:09
To: Kevin Viraud
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM
Hi,
I have an issue with a rather large CASE WHEN and I cannot figure out why
it is so slow...
First, here is my test query :
SELECT CASE WHEN dwh_company_id = 1
THEN CASE
WHEN wv.source ~ '^$' THEN 'Not tracked'
WHEN wv.source ~ '^1$' THEN 'Not tracked1'
WHEN wv.sour
