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

Peter Eisentraut <peter_e@gmx.net>

From: Peter Eisentraut <peter_e@gmx.net>
To: <nick@club.pyat.ru>, <pgsql-bugs@postgresql.org>
Date: 2001-05-03T15:44:24Z
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@gmx.net   http://funkturm.homeip.net/~peter