max / min explain

From: adb <adb(at)Beast(dot)COM>
To: pgsql-general(at)postgresql(dot)org
Subject: max / min explain
Date: 2001-02-19 22:25:35
Message-ID: Pine.GSO.4.10.10102191422490.2561-100000@hairdini.beast.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've noticed that select max(the_primary_key) from some_table
does a table scan. Is there any plan to implement max/min calculations
using index lookups if the appropriate index exists?

Thanks,

Alex.

Browse pgsql-general by date

  From Date Subject
Next Message Dan Lyke 2001-02-19 22:49:45 A How-To: PostgreSQL from Tcl via ODBC
Previous Message Stephan Szabo 2001-02-19 21:10:43 Re: not using table aliases in where clause slow-down?