Postgres Pro
Downloads
Home   >   mailing lists

Re: max() versus order/limit (WAS: High update - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: max() versus order/limit (WAS: High update
Date
Msg-id 20070115103809.GI7233@alvh.no-ip.org
Whole thread Raw
In response to Re: max() versus order/limit (WAS: High update  ("Luke Lonergan" <LLonergan@greenplum.com>)
List pgsql-performance
Tree view 
Luke Lonergan wrote:
> Adam,
>
> This optimization would require teaching the planner to use an index for
> MAX/MIN when available.  It seems like an OK thing to do to me.

This optimization already exists, albeit for queries that use a single
table.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: max() versus order/limit (WAS: High update activity, PostgreSQL vs BigDBMS)
Next
From: "Steinar H. Gunderson"
Date:
Subject: Re: pg_trgm performance