From: | "Valsecchi, Patrick" <patrick(dot)valsecchi(at)nagrastar(dot)com> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Indexes not used for "min()" |
Date: | 2003-07-29 15:48:37 |
Message-ID: | 4E2CE3FB9E1B744482F6669A9AE2F72E68F08B@NSTAREXCH1.windows.nagrastar.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Your name : Patrick
Your email address : Valsecchi
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium
Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.20
PostgreSQL version (example: PostgreSQL-7.3.3): PostgreSQL-7.3.3
Compiler used (example: gcc 2.95.2) : gcc 3.2
Please enter a FULL description of your problem:
------------------------------------------------
When doing the following query, it's obvious that postgres should use
the index:
stats=# explain select min(time) from call;
QUERY PLAN
------------------------------------------------------------------------
Aggregate (cost=49779.82..49779.82 rows=1 width=8)
-> Seq Scan on stb_call (cost=0.00..44622.06 rows=2063106 width=8)
(2 rows)
stats=# \d call
Table "public.call"
Column | Type | Modifiers
---------+--------------------------+-----------
a | integer | not null
b | integer | not null
time | timestamp with time zone | not null
d | character varying(4) |
e | character varying(4) |
f | character varying(4) |
g | character varying(15) | not null
h | character varying(7) |
i | smallint | not null
Indexes: call_time btree ("time")
stats=# select count(*) from call;
count
---------
2063106
(1 row)
If you have any question or comment, please contact me directly, I'm not
suscribed to the list.
From | Date | Subject | |
---|---|---|---|
Next Message | Vasko Miovski | 2003-07-29 15:59:13 | Re: pg_dump error |
Previous Message | Hunter Hillegas | 2003-07-28 23:32:25 | Re: Can't Build 7.3.4 on OS X |