2009/10/29 Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx>
On Wed, Oct 28, 2009 at 6:13 PM, Anj Adu <fotographs@xxxxxxxxx> 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
