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

From: John Siracusa <siracusa(at)mindspring(dot)com>
To: Postgres Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Select max(foo) and select count(*) optimization
Date: 2004-01-05 20:01:18
Message-ID: BC1F2CBE.713D1%siracusa@mindspring.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Rod Taylor 2004-01-05 20:14:24 Re: deferred foreign keys
Previous Message David Teran 2004-01-05 19:57:47 Re: optimizing Postgres queries