| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Keith Gray <keith(at)heart(dot)com(dot)au> |
| Cc: | PostgreSQL Mailing List <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Slow performance on MAX(primary_key) |
| Date: | 2002-10-17 09:26:52 |
| Message-ID: | 200210170926.53170.dev@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gaetano Mendola | 2002-10-17 12:58:53 | Re: functions that return a dataset or set of rows |
| Previous Message | Joseph Syjuco | 2002-10-17 09:11:44 | getting the current date |