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 BB980D1B341 for ; Thu, 5 Aug 2004 12:42:08 -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 97944-02 for ; Thu, 5 Aug 2004 15:42:04 +0000 (GMT) Received: from sardegna.mbigroup.it (ns1.mbigroup.it [213.188.200.195]) by svr1.postgresql.org (Postfix) with ESMTP id 290F6D1B229 for ; Thu, 5 Aug 2004 12:41:58 -0300 (ADT) Received: from mailserver.bo.mbigroup.it (localhost.localdomain [127.0.0.1]) by sardegna.mbigroup.it (8.12.10/8.12.10) with ESMTP id i75FfuPM030689; Thu, 5 Aug 2004 17:41:56 +0200 Received: from [127.0.0.1] (acasula.dev.mbigroup.it [192.168.21.15]) by mailserver.bo.mbigroup.it (8.11.6/8.11.6) with ESMTP id i75Fd0909402; Thu, 5 Aug 2004 17:39:00 +0200 Message-ID: <41125519.9090907@bigfoot.com> Date: Thu, 05 Aug 2004 17:41:13 +0200 From: Gaetano Mendola User-Agent: Mozilla Thunderbird 0.7.1 (Windows/20040626) X-Accept-Language: en-us, en MIME-Version: 1.0 To: G u i d o B a r o s i o , "pgsql-performance@postgresql.org" Subject: Re: Temporary tables References: <20040805143320.70E4A6C695@tino.sinectis.com.ar> In-Reply-To: <20040805143320.70E4A6C695@tino.sinectis.com.ar> X-Enigmail-Version: 0.84.2.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200408/69 X-Sequence-Number: 7705 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD4DBQFBElSx7UpzwH2SGd4RAhnkAKDABtA1fZSCCF/WAP5TUBJnHdWHYACWLjjQ LgncGg4+b0lPCQbafXVG6w== =1f1i -----END PGP SIGNATURE-----