Re: Problem with default partition pruning

From: Ibrar Ahmed <ibrar(dot)ahmad(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Cc: Yuzuko Hosoya <yuzukohosoya(at)gmail(dot)com>
Subject: Re: Problem with default partition pruning
Date: 2019-03-04 17:29:00
Message-ID: 155172054069.16480.11098561831487695843.pgcf@coridan.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ibrar Ahmed 2019-03-04 17:36:40 Re: Problem with default partition pruning
Previous Message Andres Freund 2019-03-04 17:27:39 Re: Minimal logical decoding on standbys