Re: Problem with default partition pruning - Mailing list pgsql-hackers

From Ibrar Ahmed
Subject Re: Problem with default partition pruning
Date
Msg-id 155172054069.16480.11098561831487695843.pgcf@coridan.postgresql.org
Whole thread Raw
In response to RE: Problem with default partition pruning  ("Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>)
Responses Re: Problem with default partition pruning
List 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)

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Minimal logical decoding on standbys
Next
From: Ibrar Ahmed
Date:
Subject: Re: Problem with default partition pruning