Re: for/loop performance in plpgsql ?

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