Re: partition pruning doesn't work with IS NULL clause in multikey range partition case

From: Dilip Kumar <dilipbalaut(at)gmail(dot)com>
To: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
Cc: amul sul <sulamul(at)gmail(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Subject: Re: partition pruning doesn't work with IS NULL clause in multikey range partition case
Date: 2018-07-12 06:09:53
Message-ID: CAFiTN-vzMEo1Rw4Hp5UDAgc5nW13=5CLZwxcLhvqFG+YUehaxA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jul 12, 2018 at 11:10 AM, Amit Langote
<Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> wrote:
> On 2018/07/12 14:32, Amit Langote wrote:
>> Thanks Ashutosh for reporting and Dilip for the analysis and the patch.

>>
>> I think your fix is correct. I slightly modified it along with updating
>> nearby comments and added regression tests.

Thanks, Your changes look fine to me.

--
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Yugo Nagata 2018-07-12 06:35:53 Re: Temporary WAL segments files not cleaned up after an instance crash
Previous Message Amit Langote 2018-07-12 05:40:30 Re: partition pruning doesn't work with IS NULL clause in multikey range partition case