On 2/7/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> For test 8 on PostgreSQL, what's EXPLAIN ANALYZE for one of those show?
test=# EXPLAIN ANALYZE SELECT count(*), avg(b) FROM t2 WHERE b>=0 AND b<100;
QUERY PLAN
---------------------------------------------------------------------------------------------------------
------
Aggregate (cost=6.02..6.03 rows=1 width=4) (actual time=0.183..0.185
rows=1 loops=1)
-> Index Scan using i2b on t2 (cost=0.00..6.01 rows=1 width=4)
(actual time=0.030..0.108 rows=12 loo
ps=1)
Index Cond: ((b >= 0) AND (b < 100))
Total runtime: 0.510 ms
(4 rows)
> What changes have you made to the default postgresql.conf?
None.
--
Nemanja Corlija <[EMAIL PROTECTED]>
