Re: performance question (something to do w/ parameterized - Mailing list pgsql-performance

From Jeffrey Tenny
Subject Re: performance question (something to do w/ parameterized
Date
Msg-id 445F9F6B.9040200@comcast.net
Whole thread Raw
In response to Re: performance question (something to do w/ parameterized stmts?, wrong index types?)  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: performance question (something to do w/ parameterized  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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?
>

pgsql-performance by date:

Previous
From: Vivek Khera
Date:
Subject: Re: Memory and/or cache issues?
Next
From: Tom Lane
Date:
Subject: Re: Query runs 38 seconds for small database!