Re: Problem with default partition pruning
| От | Ibrar Ahmed |
|---|---|
| Тема | Re: Problem with default partition pruning |
| Дата | |
| Msg-id | CALtqXTdonzDJEMPKf-M5OxRx64G3=oYXsunuxaVJc=uSs4oWWg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Problem with default partition pruning (Ibrar Ahmed <ibrar.ahmad@gmail.com>) |
| Ответы |
Re: Problem with default partition pruning
|
| Список | pgsql-hackers |
Hi Yuzuko Hosoya,
Ignore my last message, I think this is also a legitimate scan on default partition.
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
В списке pgsql-hackers по дате отправления: