Re: [PERFORM] Partitioned tables in queries

2006-07-21 Thread Kevin Keith
in the query must be a constant, and cannot be a result of a built-in function in order for constraint_exclusion to work correctly? Thanks, Kevin Kevin Keith wrote: I have a case where I am partitioning tables based on a date range in version 8.1.4. For example: table_with_millions_of_

[PERFORM] Partitioned tables in queries

2006-07-21 Thread Kevin Keith
I have a case where I am partitioning tables based on a date range in version 8.1.4. For example: table_with_millions_of_records interaction_id char(16) primary key start_date timestamp (without timezone) - indexed .. other columns child_1 start_date >= 2006-07-21 00:00:00 child_2 start_