Why idex scan not used? - Mailing list pgsql-admin

From Andrei N.Sobchuck
Subject Why idex scan not used?
Date
Msg-id 000701bf829e$e4447ac0$4301a8c0@mart.cherkassy.ua
Whole thread Raw
Responses Re: [ADMIN] Why idex scan not used?
List pgsql-admin
=> create table t(id int4 primary key);
=> explain select min(id) from t;
NOTICE:  QUERY PLAN:
Aggregate  (cost=43.00 rows=1000 width=4)
  ->  Seq Scan on t  (cost=43.00 rows=1000 width=4)
EXPLAIN

Is it possible to make postgresql to use index scan when it calculate
MIN(id).


pgsql-admin by date:

Previous
From: Michael Holopainen
Date:
Subject: HELP, Postgres stops accepting connections from Unix socket
Next
From: Peter Eisentraut
Date:
Subject: Re: [ADMIN] Why idex scan not used?