Re: Problem with default partition pruning

Поиск
Список
Период
Сортировка
От yuzuko
Тема Re: Problem with default partition pruning
Дата
Msg-id CAKkQ50-AR185kjHyMgr6-V1GVrrEv+XHxE_UC_fiRa3GvMa5rw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Problem with default partition pruning  (Ibrar Ahmed <ibrar.ahmad@gmail.com>)
Список pgsql-hackers
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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: David Steele
Дата:
Сообщение: Re: NOT IN subquery optimization
Следующее
От: "Matwey V. Kornilov"
Дата:
Сообщение: Re: [PATCH 0/3] Introduce spgist quadtree @<(point,circle) operator