Re: pg 7.4.rc1, Range query performance

--- Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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