Re: Temp table or normal table for performance? - Mailing list pgsql-general

From Ivan Sergio Borgonovo
Subject Re: Temp table or normal table for performance?
Date
Msg-id 20090821142338.5b65aff4@dawn.webthatworks.it
Whole thread Raw
In response to Re: Temp table or normal table for performance?  (Jasen Betts <jasen@xnet.co.nz>)
List pgsql-general
On 20 Aug 2009 13:43:10 GMT
Jasen Betts <jasen@xnet.co.nz> wrote:

> On 2009-08-19, Stephen Cook <sclists@gmail.com> wrote:
>
> > Let's say I have a function that needs to collect some data from
> > various tables and process and sort them to be returned to the
> > user.
>
> plpgsql functions don't play well with temp tables IME.

Why?

you mean that since you generally use temp table for computation and
looping several times over the table... a more expressive language
would be suited?


--
Ivan Sergio Borgonovo
http://www.webthatworks.it


pgsql-general by date:

Previous
From: David Waller
Date:
Subject: "Number of columns exceed limit" on a hierarchy of views
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Temp table or normal table for performance?