Home > mailing lists

Re: SELECT min(id) FROM test; uses seqscan - Mailing list pgsql-bugs

From	Peter Eisentraut
Subject	Re: SELECT min(id) FROM test; uses seqscan
Date	May 3, 2001 16:00:08
Msg-id	Pine.LNX.4.30.0105031743300.900-100000@peter.localdomain Whole thread Raw
In response to	SELECT min(id) FROM test; uses seqscan (pgsql-bugs@postgresql.org)
List	pgsql-bugs

Tree view

> 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

pgsql-bugs by date:

From: Tom Lane
Date: 03 May 2001, 15:31:05
Subject: Re: PostgreSQL bug in SELECT DISTINCT

From: antipode@thpoon.com
Date: 03 May 2001, 16:32:17
Subject: Documentation bug for pg_ctl (-s option not documented)

Re: SELECT min(id) FROM test; uses seqscan - Mailing list pgsql-bugs

Previous

Next