Re: pg 7.4.rc1, Range query performance

--- Bruce Momjian <pgman@candle.pha.pa.us> wrote:
> Strange 30 records takes 30x the time than one record.  Can you run
> ANALYZE and send us an EXPLAIN of the query to make sure it hasn't
> changed?
> 

explain analyze select * from Test
where a >= '2002-06-18' and a <= '2002-07-18' and b = 5 and c = 255

QUERY PLAN
Index Scan using ak_abc on test  (cost=0.00..121.23 rows=34 width=53) (actual
time=18.060..10726.387 rows=31 loops=1) Index Cond: (((a)::timestamp without time zone >= '2002-06-18
00:00:00'::timestamp without time zone) AND ((a)::timestamp without time zone
<= '2002-07-18 00:00:00'::timestamp without time zone) AND ((b)::integer = 5)
AND ((c) (..)
Total runtime: 10726.663 ms

Thanks







__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree