Re: Planning large IN lists - Mailing list pgsql-hackers

From Atul Deopujari
Subject Re: Planning large IN lists
Date
Msg-id 464D21CD.5060907@enterprisedb.com
Whole thread Raw
In response to Re: Planning large IN lists  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

Tom Lane wrote:
> "Atul Deopujari" <atuld@enterprisedb.com> writes:
>> Yes, letting the planner make its own decision would seem best (in 
>> accordance with what we do for different join paths). But for large IN 
>> lists, a substantial part of the planner is spent in estimating the 
>> selectivity of the ScalarArrayExpr by calling scalararraysel. If we are 
>> not eliminating this step in processing the IN list then we are not 
>> doing any optimization. Asking the planner to do scalararraysel and also 
>> compute cost of any other way and choose between the two is asking 
>> planner to do more work.
> 
> So?  Better planning usually involves more work.  In any case the above
> argument seems irrelevant, because making scalararraysel more
> approximate and less expensive for long lists could be done
> independently of anything else.
> 
Got you and agree with you.

-- 
Atul

EnterpriseDB
www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: Not ready for 8.3
Next
From: Magnus Hagander
Date:
Subject: Re: What is happening on buildfarm member baiji?