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

Re: Very slow stored proc

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Együd Csaba (Freemail) <csegyud(at)freemail(dot)hu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Very slow stored proc
Date: 2004-12-23 22:11:44
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On Thu, Dec 23, 2004 at 09:48:56PM +0100, Együd Csaba (Freemail) wrote:


> Dear Alvarao,

Wow, now that's a strange misspelling.  I've seen several but this one
is new to me :-D

> would you please so kind explaining me your opinion in details.

What do you want that table for?  If you are using it as input for a
query, it's possible that you can forget about refilling it every now
and then, and instead using a set-returning function (SRF) in the FROM
clause of said query.

Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"I dream about dreams about dreams", sang the nightingale
under the pale moon (Sandman)

In response to


pgsql-general by date

Next:From: Derik BarclayDate: 2004-12-23 22:13:42
Subject: Making a varchar bigger
Previous:From: Alvaro HerreraDate: 2004-12-23 22:07:58
Subject: Re: BTree max row size?

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