Re: Indexes not used for "min()"

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "Valsecchi, Patrick" <patrick(dot)valsecchi(at)nagrastar(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Indexes not used for "min()"
Date: 2003-08-04 20:58:15
Message-ID: 20030804205815.GA14136@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Jul 29, 2003 at 09:48:37 -0600,
"Valsecchi, Patrick" <patrick(dot)valsecchi(at)nagrastar(dot)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;

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Eric Johnson 2003-08-05 03:48:08 Re: Using contrib/fulltext on multiple tables.
Previous Message Tom Lane 2003-08-04 20:53:24 Re: html tarball not found in doc/Makefile