Re: Slow performance on MAX(primary_key)
Richard Huxton <dev@archonet.com>
From: Richard Huxton <dev@archonet.com>
To: Keith Gray <keith@heart.com.au>
Cc: PostgreSQL Mailing List <pgsql-sql@postgresql.org>
Date: 2002-10-17T09:26:52Z
Lists: 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