Hi Ibrar, On Tue, Mar 5, 2019 at 2:37 AM Ibrar Ahmed <ibrar.ah...@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.ah...@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
