On 23 January 2018 at 23:22, Amit Langote <langote_amit...@lab.ntt.co.jp> wrote: > On 2018/01/23 15:44, David Rowley wrote: >> Attached is what I had in mind about how to do this. > > Thanks for the delta patch. I will start looking at it tomorrow.
Thanks. I've been looking more at this and I've made a few more adjustments in the attached. This delta patch should be applied against the faster_partition_prune_v21_delta_drowley_v1.patch one I sent yesterday. This changes a few comments, also now correctly passes the context to get_partitions_excluded_by_ne_clauses and fixes a small error where the patch was failing to record a notnull for the partition key when it saw a strict <> clause. It was only doing this for the opposite case, but both seem to be perfectly applicable. I also made a small adjustment to the regression tests to ensure this is covered. I'm now going to start work on basing the partition pruning patch on top of this. -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
faster_partition_prune_v21_delta_drowley_v1_delta.patch
Description: Binary data
