Re: [HACKERS] Runtime Partition Pruning

From: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
To: Beena Emerson <memissemerson(at)gmail(dot)com>
Cc: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, Robert Haas <robertmhaas(at)gmail(dot)com>, amul sul <sulamul(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>
Subject: Re: [HACKERS] Runtime Partition Pruning
Date: 2017-12-21 13:32:33
Message-ID: CAKJS1f9QEOnmCy+QMuGTM1pHn8X1NwMRmm8sCBhL-avBEFU+Uw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 22 December 2017 at 02:06, Beena Emerson <memissemerson(at)gmail(dot)com> wrote:
>> Thanks for sending. Will the tests still pass if you remove the hack
>> from choose_custom_plan()?
>>
>
> The hack has been removed in the v7 patch sent and yes the tests work
> without any additional adjustments.

Oh nice. I see you've included parameters to force the 5 custom plans
to having a higher cost, then for the first generic plan attempt,
you're choosing params that'll result in a cheaper plan. Great idea.
I'll revoke what I said about this being impossible to test now :)

--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2017-12-21 13:45:18 Re: Reproducible builds: genbki.pl and Gen_fmgrtab.pl
Previous Message Michael Paquier 2017-12-21 13:27:19 Re: Reproducible builds: genbki.pl and Gen_fmgrtab.pl