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

> 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