Re: SELECT min(id) FROM test; uses seqscan

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: <nick(at)club(dot)pyat(dot)ru>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: SELECT min(id) FROM test; uses seqscan
Date: 2001-05-03 15:44:24
Message-ID: Pine.LNX.4.30.0105031743300.900-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> SELECT min(id) FROM test; uses sequential scan even if an index on "id" exists. VACUUM ANALYZE doesn't help.

This is not a bug. In the current implementation, min and max cannot make
use of an index directly.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2001-05-03 15:55:06 Re: \dT macaddr helptext bug.
Previous Message Peter Eisentraut 2001-05-03 15:39:09 Re: freebsd sample startup script doesn't work