X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6DC7D5E46C7 for ; Fri, 6 Aug 2004 13:11:14 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13919-09 for ; Fri, 6 Aug 2004 16:11:16 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 9152F5E46C5 for ; Fri, 6 Aug 2004 13:11:08 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i76GB65p081375 for ; Fri, 6 Aug 2004 16:11:13 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i76G1iS3080137 for pgsql-performance@postgresql.org; Fri, 6 Aug 2004 16:01:44 GMT From: Gaetano Mendola X-Newsgroups: comp.databases.postgresql.performance Subject: Re: Temporary tables Date: Thu, 05 Aug 2004 17:37:50 +0200 Organization: PYRENET Midi-pyrenees Provider Lines: 30 Message-ID: <4112544E.2060706@bigfoot.com> References: <20040805143320.70E4A6C695@tino.sinectis.com.ar> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@pyrenet.fr To: G u i d o B a r o s i o User-Agent: Mozilla Thunderbird 0.7.1 (Windows/20040626) X-Accept-Language: en-us, en In-Reply-To: <20040805143320.70E4A6C695@tino.sinectis.com.ar> X-Enigmail-Version: 0.84.2.0 X-Enigmail-Supports: pgp-inline, pgp-mime To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/76 X-Sequence-Number: 7712 G u i d o B a r o s i o wrote: > The box: > Linux 2.4.24-ck1 > 8 Intel(R) Xeon(TM) MP CPU 2.80GHz > 4 gb RAM. > Postgresql 7.4.2 > > The problem: > Short in disk space. (waiting new hard) > > The real problem: > Developers usually write queries involving the creation of temporary tables. I seen too this behavior, till I explained that this is a valid sql: select T.* from ( select * from table t where a = 5 ) AS T join foo using ( bar ); show us a typical function that use temporary tables. Regards Gaetano Mendola