MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII;
 format=flowed
Content-Transfer-Encoding: 7bit
Date: Fri, 25 Aug 2017 09:06:00 +0200
From: vinny <vinny@xs4all.nl>
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: query runs for more than 24 hours!
In-Reply-To: 
 <CA+t6e1m0ot7PTHDOVTjVu1M5u1VH5d7p6yYm5-eqP7KnoffWNw@mail.gmail.com>
References: 
 <CA+t6e1m0ot7PTHDOVTjVu1M5u1VH5d7p6yYm5-eqP7KnoffWNw@mail.gmail.com>
Message-ID: <754d24d26f8a4da4e3a3d43157d7a036@xs4all.nl>
User-Agent: XS4ALL Webmail
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

On 2017-08-22 16:23, Mariel Cherkassky wrote:

> 
> SELECT a.inst_prod_id,
>                                            product_id,
>                           nap_area2,
>                                            nap_phone_num,
>                              nap_product_id,
>                                            b.nap_discount_num,
>                                   b.nap_makat_cd,
>                                            nap_act_start_dt,
>                                 b.nap_debt_line,
>                                            nap_act_end_dt,
>                                            b.row_added_dttm
>                                b.row_lastmant_dttm,
>                                     FROM   ps_rf_inst_prod a,
>                                     AND    a.setid  || ''= 'SHARE'
>                                       nap_ip_discount b
>                                     WHERE  nap_crm_status  = 'C_04'
>                                     AND    b.nap_makat_cd IN (SELECT
> term_code                                    AND    b.setid  || ''=
> 'SHARE'
>                                     AND    a.inst_prod_id =


On my screen the order of the lines in the query seem to get messed up,
I'm not sure if that's my email program or a copy/paste error.

 From what I can see, you are using subselects in an IN statement,
which can be a problem if that has to be re-evaluated a lot.

It's hard for me to say more because I can't tell what the actual query 
is at the moment.

Regards, Vincent.


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance