Postgres Pro
Downloads
Home   >   mailing lists

Re: not using index for select min(...) - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: not using index for select min(...)
Date
Msg-id 20030131183104.L24535@mail.libertyrms.com
Whole thread Raw
In response to not using index for select min(...)  (Don Bowman <don@sandvine.com>)
List pgsql-performance
Tree view 
On Fri, Jan 31, 2003 at 04:12:38PM -0500, Don Bowman wrote:
> Why wouldn't I be doing an index scan on this table?

Because you're using the aggregate function min().  See

<http://www.ca.postgresql.org/docs/faq-english.html#4.8>

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: not using index for select min(...)
Next
From: Bruno Wolff III
Date:
Subject: Re: not using index for select min(...)