Re: performance question (something to do w/ parameterized

From: Jeffrey Tenny <jeffrey(dot)tenny(at)comcast(dot)net>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: performance question (something to do w/ parameterized
Date: 2006-05-08 19:43:39
Message-ID: 445F9F6B.9040200@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

Well, since I don't know the exact parameter values, just substituting
1-650 for $1-$650, I get:

Index Scan using testindex2 on x (cost=0.00..34964.52 rows=1503
width=16) (actual time=0.201..968.252 rows=677 loops=1)
Filter: ((f = 1) OR (f = 2) OR (f = 3) OR (f = 4) ...

So index usage is presumably good on this one.

Jim C. Nasby wrote:
> What's EXPLAIN ANALYZE show?
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeffrey Tenny 2006-05-08 19:51:26 Re: performance question (something to do w/ parameterized
Previous Message Volkan YAZICI 2006-05-08 19:38:02 Re: intarray internals

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-05-08 19:48:38 Re: Query runs 38 seconds for small database!
Previous Message Vivek Khera 2006-05-08 19:38:23 Re: Memory and/or cache issues?