Re: memory optimization

From: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: memory optimization
Date: 2007-08-16 06:17:37
Message-ID: fa0q5o$61j$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick TJ McPhee 2007-08-16 06:33:01 Re: memory optimization
Previous Message Phoenix Kiula 2007-08-16 05:50:07 Re: Fastest way to import only ONE column into a table? (COPY doesn't work)