Parent table has a column say column1 which is indexed (parent table and all child tables are indexed on that column)
When a select max(column1) is done on parent table..takes a very long time to get back with the result
The same query on a child table gives instantaneous response (the tables are quite large appx.each child table has about 20-30 million rows)
Constraint exclusion is turned on. The column is not the basis for partitioning. Postgres 8.1.2