Re: Slow performance on MAX(primary_key) - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Slow performance on MAX(primary_key)
Date
Msg-id 200210170926.53170.dev@archonet.com
Whole thread Raw
In response to Re: Slow performance on MAX(primary_key)  (Keith Gray <keith@heart.com.au>)
List pgsql-sql
On Thursday 17 Oct 2002 12:46 am, Keith Gray wrote:
> Getting MIN() adn MAX() seems fairly trivial to me.
>
> When is on an index or more importantly Primary
> Key it must be a common SQL.
>
> Would it be possible in the code to look at
> the field in MIN() or MAX() and if it is
> indexed use a similar method to the suggested
> SQL work around?
>
> Can I help this to happen?

Subscribe to pgsql-hackers and talk through a proposed hack there. The
developers always seem happy to receive contributions (you've just got to
look at the contrib folder for evidence).

--  Richard Huxton


pgsql-sql by date:

Previous
From: Ludwig Lim
Date:
Subject: Re: getting the current date
Next
From: "Gaetano Mendola"
Date:
Subject: Re: functions that return a dataset or set of rows