select max(parent_table) slow - Mailing list pgsql-admin

From Anj Adu
Subject select max(parent_table) slow
Date
Msg-id f2fd819a0908180630s6737390fs5d91c5ae211e7bf1@mail.gmail.com
Whole thread Raw
Responses Re: select max(parent_table) slow  (Kenneth Marshall <ktm@rice.edu>)
Re: select max(parent_table) slow  ("Plugge, Joe R." <JRPlugge@west.com>)
List pgsql-admin
We are testing 8.4 and noticed that the performance of

select max(indexed_col) from parent_Table

is the same (slow) as postgres 8.1.x ( our current version).    The
child tables are huge and the indexed_col is not the basis for
partitioning.

I remember that this was an issue from an earlier thread where the
optimizer was not able to use the child partitions only to get the max
value. Is this true for 8.4 ?

pgsql-admin by date:

Previous
From: bilal ghayyad
Date:
Subject: I know part of the function name, how I can search for it from the CLI
Next
From: Kenneth Marshall
Date:
Subject: Re: select max(parent_table) slow