Re: Problem with default partition pruning

Hi Ibrar,

On Tue, Mar 5, 2019 at 2:37 AM Ibrar Ahmed <ibrar.ahmad@gmail.com> wrote:
>
> Hi  Yuzuko Hosoya,
>
> Ignore my last message, I think this is also a legitimate scan on default partition.
>
Oh, I got it.  Thanks a lot.

>
> On Mon, Mar 4, 2019 at 10:29 PM Ibrar Ahmed <ibrar.ahmad@gmail.com> wrote:
>>
>> Hi
>>
>> Patch work fine to me, but I have one test case where default partition still scanned.
>>
>> postgres=# explain select * from test1 where (id < 10) and true;
>>                             QUERY PLAN
>> -------------------------------------------------------------------
>>  Append  (cost=0.00..55.98 rows=846 width=36)
>>    ->  Seq Scan on test1_1  (cost=0.00..25.88 rows=423 width=36)
>>          Filter: (id < 10)
>>    ->  Seq Scan on test1_def  (cost=0.00..25.88 rows=423 width=36)
>>          Filter: (id < 10)
>> (5 rows)
>
>
>
> --
> Ibrar Ahmed

-- 
Best regards,
Yuzuko Hosoya
NTT Open Source Software Center