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

Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>

From: Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>

To: amul sul <sulamul@gmail.com>

Cc: Dmitry Dolgov <9erthalion6@gmail.com>, Thomas Munro <thomas.munro@enterprisedb.com>, 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: 2019-01-21T12:09:38Z

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

(2019/01/21 20:56), amul sul wrote:
> On Mon, Nov 26, 2018 at 9:33 PM Dmitry Dolgov <9erthalion6@gmail.com
> <mailto:9erthalion6@gmail.com>> wrote:
>
>      > On Mon, Nov 26, 2018 at 1:41 PM Dmitry Dolgov
>     <9erthalion6@gmail.com <mailto: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).

> 0003 patch need a rebase.

Will do.

Thank you for letting us know!

Best regards,
Etsuro Fujita