> Thanks to all who responded to my question on querying on cluster index > names. > I have another question. We are considering partitioning 2 or 3 of our > larger tables. > Each has 12 million or more rows. We want to partition on customer_id and > build > Primary key indexes on each of the children partitions which inherit column > characteristics > From the master table. This would resolve any issues about queries on > customer-id. > My question is this: How would I handle a query that queries > On another Non-partitioned column, say, ENTRY_DATE? Could I design an index > On the master table that would reference ENTRY-DATE across partitions or > will > I need to build indexes and queries on each partition? I haven't done too much partitioning yet, but this is where I would start looking first: http://www.postgresql.org/docs/8.1/interactive/ddl-partitioning.html Regards, Richard Broersma Jr.
