On Friday 15 Nov 2002 12:31 pm, Federico wrote:
> 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 ?
Well - the query might well be pre-parsed which means it wouldn't notice any
updated stats. Can you provide an example of your code?
--
Richard Huxton
Archonet Ltd