Re: performance question (something to do w/ parameterized

Поиск
Список
Период
Сортировка
От Jeffrey Tenny
Тема Re: performance question (something to do w/ parameterized
Дата
Msg-id 445F9F6B.9040200@comcast.net
обсуждение исходный текст
Ответ на Re: performance question (something to do w/ parameterized stmts?, wrong index types?)  ("Jim C. Nasby" <jnasby@pervasive.com>)
Ответы Re: performance question (something to do w/ parameterized  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Vivek Khera
Дата:
Сообщение: Re: Memory and/or cache issues?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Query runs 38 seconds for small database!