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 ?
pgsql-performance by date
|Next:||From: Andrew Sullivan||Date: 2002-11-15 12:59:17|
|Subject: Re: [GENERAL] Upgrade to dual processor machine?|
|Previous:||From: Henrik Steffen||Date: 2002-11-15 10:11:06|
|Subject: Re: [PERFORM] Upgrade to dual processor machine?|