Re: memory optimization - Mailing list pgsql-general

From Sabin Coanda
Subject Re: memory optimization
Date
Msg-id fa0q5o$61j$1@news.hub.org
Whole thread Raw
In response to memory optimization  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
Responses Re: memory optimization  (Decibel! <decibel@decibel.org>)
List pgsql-general
>>
>> So, what is better from the postgres memory point of view: to use
>> temporary
>> objects, or to use common variables ?
>
>A temp table might take *slightly* more room than variables...
>
>> Can you suggest me other point of views to be taken into consideration in
>> my
>> case ?
>
>Code maintenance. I can't think of anyway to replace a temp table with
>variables that isn't a complete nightmare.

With some conversion procedures that is even easiest to do it ;)

Regards,
Sabin



pgsql-general by date:

Previous
From: "Phoenix Kiula"
Date:
Subject: Re: Fastest way to import only ONE column into a table? (COPY doesn't work)
Next
From: "Mikko Partio"
Date:
Subject: PostgreSQL clustering (shared disk)