for/loop performance in plpgsql ?

Поиск
Список
Период
Сортировка
От Federico
Тема for/loop performance in plpgsql ?
Дата
Msg-id 20021115123156.GB785@protciv14.cmirl.arpal.it
обсуждение исходный текст
Ответы Re: for/loop performance in plpgsql ?  (Richard Huxton <richardh@archonet.com>)
Список pgsql-performance
Hi all,

i've a doubt about how FOR/LOOP works in plpgsql.

It seems to me that the SELECT query executed in that way is much slower
that the same being executed interactively in psql.

In particular it seems that it doesn't make use of indexes.

Does it have any sense or am i wrong/missing something ?

Thanks all.

Ciao

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Henrik Steffen"
Дата:
Сообщение: Re: [GENERAL] Upgrade to dual processor machine?
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: [GENERAL] Upgrade to dual processor machine?