Re: Indexes not used for "min()" - Mailing list pgsql-bugs

On Tue, Jul 29, 2003 at 09:48:37 -0600,
  "Valsecchi, Patrick" <patrick.valsecchi@nagrastar.com> wrote:
>
> When doing the following query, it's obvious that postgres should use
> the index:
>
> stats=# explain select min(time) from call;

This has been discussed on the mailing lists numerous times. If you are
interested in details you can search the archives. If you just want a faster
equivalent query use:
select time from call order by time limit 1;