Re: Runtime partition pruning for MergeAppend

Hi

2018-07-19 12:50 GMT+02:00 Heikki Linnakangas <hlinnaka(at)iki(dot)fi>:

> On 18/06/18 13:29, David Rowley wrote:
>
>> Back in the v11 cycle, there was just not quite enough time to get the
>> MergeAppend run-time partition pruning patch in.
>>
>> I've attached v24 of this patch. The only changes done from v23 [1]
>> are to re-base the patch atop of current master. There's was a bit of
>> churn in the partition pruning and run-time pruning code last week.
>> I've re-aligned the new code to account for the work done there.
>>
>
> Looks solid. The only actual bug I see is that this doesn't honor the
> enable_partition_pruning GUC, but that's trivial to fix. So fixed that,
> reworded some of the comments a tiny bit, and committed. Thanks!
>

small note

for getting custom plan, you don't need execute 5x now. Just use
plan_cache_mode GUC.

Regards

Pavel

>
> - Heikki
>
>