Re: [HACKERS] advanced partition matching algorithm for partition-wise join

Dmitry Dolgov <9erthalion6@gmail.com>

From: Dmitry Dolgov <9erthalion6@gmail.com>

To: Thomas Munro <thomas.munro@enterprisedb.com>

Cc: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>, Antonin Houska <ah@cybertec.at>, Robert Haas <robertmhaas@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>, ashutosh.bapat.oss@gmail.com

Date: 2018-11-26T16:03:57Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Suppress unused-variable warning.
- 401418ca6a68 13.0 landed
Allow partitionwise joins in more cases.
- c8434d64ce03 13.0 landed
Avoid crash in partitionwise join planning under GEQO.
- 7ad6498fd5a6 12.0 cited
- d70c147fa217 11.3 cited
Disable support for partitionwise joins in problematic cases.
- 7cfdc77023ad 12.0 cited
Add plan_cache_mode setting
- f7cb2842bf47 12.0 cited
Add test for partitionwise join involving default partition.
- 4513d3a4be0b 12.0 cited
Revise API for partition_rbound_cmp/partition_rbound_datum_cmp.
- b0229235564f 11.0 landed

Attachments

0002-Targetlist-of-a-child-join-is-produced-by-translating-v15.patch (application/octet-stream) patch v15-0002
0001-Hash-partition-bound-equality-refactoring-v15.patch (application/octet-stream) patch v15-0001
0003-Partition-wise-join-for-1-1-1-0-0-1-partition-matching-v15.patch (application/octet-stream) patch v15-0003
0004-Tests-for-0-1-1-1-and-1-0-partition-matching-v15.patch (application/octet-stream) patch v15-0004

> On Mon, Nov 26, 2018 at 1:41 PM Dmitry Dolgov <9erthalion6@gmail.com> wrote:
>
> Thanks, I've messed this up too - rebased a wrong branch, the correct one
> doesn't have this code already. Sorry for that, and here is the proper version
> of this patch.

And one more version, because I haven't fixed the tests (sorry for the noise).