From: | Peter Vazsonyi <neko(at)kredit(dot)sth(dot)szif(dot)hu> |
---|---|
To: | pgsql-admin(at)hub(dot)org |
Subject: | more performance on some aggregates |
Date: | 2000-02-23 12:34:04 |
Message-ID: | Pine.LNX.4.10.10002231231330.5159-100000@kredit.sth.szif.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I've created a table, and index.
Table = test
+----------------------------+----------------------------+-------+
| Field | Type | Length|
+----------------------------+----------------------------+-------+
| a | int4 | 4 |
| c | varchar | 40 |
+----------------------------+----------------------------+-------+
Index: _test_a
if i need the max or min value of column a i can get with
SELECT max(test.a); query.
If i take look on the query tree:
Aggregate (cost=43.00 rows=1000 width=4)
-> Seq Scan on test (cost=43.00 rows=1000 width=4)
...
Ok, i understand: all type of the aggregates work on same way, but...
have i any chance to get extrem values, without seq scan?
Thanx in advice
--
nek;(
From | Date | Subject | |
---|---|---|---|
Next Message | Steven Pennie | 2000-02-23 15:45:55 | Developing a Schema |
Previous Message | ty | 2000-02-23 09:15:11 | buffer & number of backends problem 6.5.3 |