select max(column) from parent table very slow - Mailing list pgsql-performance

From Sriram Dandapani
Subject select max(column) from parent table very slow
Date
Msg-id 6992E470F12A444BB787B5C937B9D4DF057500BF@ca-mail1.cis.local
Whole thread Raw
Responses Re: select max(column) from parent table very slow  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-performance

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

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: adtx
Next
From: "Joshua D. Drake"
Date:
Subject: Re: select max(column) from parent table very slow