X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F4060D1B275; Thu, 5 Aug 2004 11:33:21 -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 73305-06; Thu, 5 Aug 2004 14:33:23 +0000 (GMT) Received: from tino.sinectis.com.ar (tino.sinectis.com.ar [216.244.192.232]) by svr1.postgresql.org (Postfix) with ESMTP id B1F15D1B171; Thu, 5 Aug 2004 11:33:17 -0300 (ADT) Received: by tino.sinectis.com.ar (Postfix, from userid 99) id 70E4A6C695; Thu, 5 Aug 2004 11:33:20 -0300 (GMT+3) Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 X-Mailer: Sinectis Webmail 5.6.16-1.5.1 From: G u i d o B a r o s i o To: pgsql-performance@postgresql.org Subject: Temporary tables Cc: pgsql-admin@postgresql.org Reply-To: gbarosio@uolsinectis.com.ar Message-Id: <20040805143320.70E4A6C695@tino.sinectis.com.ar> Date: Thu, 5 Aug 2004 11:33:20 -0300 (GMT+3) 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/22 X-Sequence-Number: 14417 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. The BF question: Is a good idea to link this tmp tables to another partition? If so, how can I link this tmp tables to another partition? Suggestions? Thanks in advance! Guido