2018-07-19 12:50 GMT+02:00 Heikki Linnakangas <hlinnaka@iki.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.