more performance on some aggregates

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;(

Browse pgsql-admin by date

  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