Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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.



pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group