select max(parent_table) slow

From: Anj Adu <fotographs(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: select max(parent_table) slow
Date: 2009-08-18 13:30:15
Message-ID: f2fd819a0908180630s6737390fs5d91c5ae211e7bf1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kenneth Marshall 2009-08-18 13:38:09 Re: select max(parent_table) slow
Previous Message bilal ghayyad 2009-08-18 09:13:19 I know part of the function name, how I can search for it from the CLI