Horton

Re: Select max(foo) and select count(*) optimization

John Siracusa <siracusa@mindspring.com>

View thread View on postgr.es
From: John Siracusa <siracusa@mindspring.com>
To: Postgres Performance <pgsql-performance@postgresql.org>
Date: 2004-01-05T20:01:18Z
Lists: pgsql-performance 
On 1/5/04 2:52 PM, Rod Taylor wrote:
> max(foo) optimizations requires an extension to the aggregates system.
> It will likely happen within a few releases.

Looking forward to it.

> A work around can be accomplished today through the use of LIMIT and ORDER BY.

Wowzers, I never imagined that that'd be so much faster.  Thanks! :)

-John