Re: Make Append Cost aware of some run time partition prune case

2021-11-04 Thread Daniel Gustafsson
> On 14 Jul 2021, at 17:55, vignesh C wrote: > The patch does not apply on Head anymore, could you rebase and post a > patch. I'm changing the status to "Waiting for Author". As the thread has stalled, this patch still doesn't apply (judging by the log it's likely not too hard to resolve). I'm

Re: Make Append Cost aware of some run time partition prune case

2021-07-14 Thread vignesh C
On Thu, Mar 4, 2021 at 9:51 AM Andy Fan wrote: > > >> >> I have implemented a new one, which only handles 1 level of partitioned >> table, and >> only 1 partition key. and only handle the eq operators like partkey = $1 / >> partkey in ($1, $2) >> / parkey = $1 or partkey = $2; The patch works

Re: Make Append Cost aware of some run time partition prune case

2021-03-03 Thread Andy Fan
> > I have implemented a new one, which only handles 1 level of partitioned > table, and > only 1 partition key. and only handle the eq operators like partkey = $1 > / partkey in ($1, $2) > / parkey = $1 or partkey = $2; The patch works well in my user case. I > can send > one on the latest mast

Re: Make Append Cost aware of some run time partition prune case

2021-03-03 Thread Andy Fan
Hi Ryan: On Thu, Mar 4, 2021 at 8:14 AM Ryan Lambert wrote: > On Mon, Nov 9, 2020 at 5:44 PM Andy Fan wrote: > >> Currently the cost model of append path sums the cost/rows for all the >> subpaths, it usually works well until we run into the run-time partition >> prune >> case. The first resul

Re: Make Append Cost aware of some run time partition prune case

2021-03-03 Thread Ryan Lambert
On Mon, Nov 9, 2020 at 5:44 PM Andy Fan wrote: > Currently the cost model of append path sums the cost/rows for all the > subpaths, it usually works well until we run into the run-time partition > prune > case. The first result is that generic plans will rarely be used for some > cases. > For in