Re: pl-pgsql "return set of..." "return next..." performance question

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pl-pgsql "return set of..." "return next..." performance question
Date: 2007-11-16 18:15:38
Message-ID: 162867790711161015l3c829b7ap4f65cbdc17200b3f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

>
> I noticed that it takes a long time to return the set of records. But if I
> run the same query at the psql cli, it runs blindingly fast. So it appears
> that the process of returning the records via "return next" is the
> performance culprit.
>
> Any ideas?

Try use holdable cursors
http://www.postgresql.org/docs/8.2/interactive/plpgsql-cursors.html#PLPGSQL-CURSOR-USING

But problem can be in
http://groups.google.com/group/pgsql.general/browse_thread/thread/38aa2064fcce53ed/69b7362839c3ab4c

Regards
Pavel Stehule

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2007-11-16 18:34:40 Re: Common criteria evaluation?
Previous Message Gauthier, Dave 2007-11-16 18:03:27 pl-pgsql "return set of..." "return next..." performance question