Message-ID: <436FC9B1.4000906@telogis.com>
Date: Tue, 08 Nov 2005 10:40:01 +1300
From: Ralph Mason <ralph.mason@telogis.com>
User-Agent: Thunderbird 1.4 (Windows/20050908)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: Temporary Table
References: <004101c5e3b0$ee534130$1e21100a@ghwk02002147>
	<20051107110719.GA7012@surnet.cl>
In-Reply-To: <20051107110719.GA7012@surnet.cl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Alvaro Herrera wrote:
> Christian Paul B. Cosinas wrote:
>   
>> Does Creating Temporary table in a function and NOT dropping them affects
>> the performance of the database?
>>     
>
> The system will drop it automatically, so it shouldn't affect.
>
> What _could_ be affecting you if you execute that function a lot, is
> accumulated bloat in pg_class, pg_attribute, or other system catalogs.
> You may want to make sure these are vacuumed often.
>
>   
The answer in my experience is a very loud YES YES YES

If you use lots of temporary tables you will grow and dirty your system 
catalogs, so you need to be vacuuming them regularly also (pg_call, 
pg_attribute) Otherwise your db will slow to a crawl after a while.

Ralph