Postgres Pro
Downloads
Home   >   mailing lists

max / min explain - Mailing list pgsql-general

From adb
Subject max / min explain
Date
Msg-id Pine.GSO.4.10.10102191422490.2561-100000@hairdini.beast.com
Whole thread Raw
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: not using table aliases in where clause slow-down?
Next
From: "Donald Braman"
Date:
Subject: How do I change data type from text to bool?