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