|
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 |
