Why idex scan not used?

From: "Andrei N(dot)Sobchuck" <andrei(at)mart(dot)cherkassy(dot)ua>
To: <pgsql-admin(at)hub(dot)org>
Subject: Why idex scan not used?
Date: 2000-02-29 10:22:33
Message-ID: 000701bf829e$e4447ac0$4301a8c0@mart.cherkassy.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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).

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2000-02-29 15:54:40 Re: [ADMIN] Why idex scan not used?
Previous Message Michael Holopainen 2000-02-29 07:46:47 HELP, Postgres stops accepting connections from Unix socket