Re: Temp table or normal table for performance?

Поиск
Список
Период
Сортировка
От Ivan Sergio Borgonovo
Тема Re: Temp table or normal table for performance?
Дата
Msg-id 20090821142338.5b65aff4@dawn.webthatworks.it
обсуждение исходный текст
Ответ на Re: Temp table or normal table for performance?  (Jasen Betts <jasen@xnet.co.nz>)
Список 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 по дате отправления:

Предыдущее
От: David Waller
Дата:
Сообщение: "Number of columns exceed limit" on a hierarchy of views
Следующее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: Re: Temp table or normal table for performance?