2009/10/29 Grzegorz Jaśkiewicz <gryz...@gmail.com> > > > On Wed, Oct 28, 2009 at 6:13 PM, Anj Adu <fotogra...@gmail.com> wrote: > >> Postgres consistently does a sequential scan on the child partitions >> for this query >> >> select * from partitioned_table >> where partitioned_column > current_timestamp - interval 8 days >> where x in (select yy from z where colname like 'aaa%') >> >> If I replace the query with >> >> select * from partitioned_table >> where partitioned_column > current_timestamp - interval 8 days >> where x in (hardcode_value) >> >> The results are in line with expectation (very fast and uses a Bitmap >> Index Scan on the column X) >> \ > > > use JOIN luke.. > > > -- > GJ >
Yes you try by using Join JAK
