On Wed, Oct 28, 2009 at 6:13 PM, Anj Adu <fotographs@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
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)\
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных