Skip site navigation (1)
Skip section navigation (2)
Well, since I don't know the exact parameter values, just substituting 1-650 for $1-$650, I get:
Peripheral Links
Header And Logo
|
Site Navigation
Re: performance question (something to do w/ parameterized
- From: Jeffrey Tenny <jeffrey(dot)tenny(at)comcast(dot)net>
- To: "Jim C. Nasby" <jnasby(at)pervasive(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: performance question (something to do w/ parameterized
- Date: Mon, 08 May 2006 15:43:39 -0400
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?
- Follow-Ups:
- Re: performance question (something to do w/ parameterized
- From: Tom Lane
- Re: performance question (something to do w/ parameterized
- References:
- Prev by Date: Re: Memory and/or cache issues?
- Next by Date: Re: Query runs 38 seconds for small database!
- Previous by thread: Re: performance question (something to do w/ parameterized stmts?, wrong index types?)
- Next by thread: Re: performance question (something to do w/ parameterized
- Indexes: