for/loop performance in plpgsql ?

From: Federico <fepede(at)inwind(dot)it>
To: pgsql-performance(at)postgresql(dot)org
Subject: for/loop performance in plpgsql ?
Date: 2002-11-15 12:31:56
Message-ID: 20021115123156.GB785@protciv14.cmirl.arpal.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Sullivan 2002-11-15 12:59:17 Re: [GENERAL] Upgrade to dual processor machine?
Previous Message Henrik Steffen 2002-11-15 10:11:06 Re: [PERFORM] Upgrade to dual processor machine?