Received: from smtp011.mail.yahoo.com (smtp011.mail.yahoo.com [216.136.173.31]) by postgresql.org (8.11.3/8.11.4) with SMTP id f7ODcoP53455 for ; Fri, 24 Aug 2001 09:38:50 -0400 (EDT) (envelope-from chrup999@yahoo.com) Received: from proxy.compucom.com (HELO Z161842) (204.214.145.2) by smtp.mail.vip.sc5.yahoo.com with SMTP; 24 Aug 2001 13:38:46 -0000 X-Apparently-From: Message-ID: <001f01c12ca2$17cb2d40$5dd26383@corp.compucom.com> From: "Chris Ruprecht" To: References: <24380.997847877@sss.pgh.pa.us> Subject: Re: Temp tables being written to disk. Avoidable? [Another TO-DO] Date: Fri, 24 Aug 2001 08:38:43 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200108/299 X-Sequence-Number: 4545 (Maybe this thread is dead now, but here goes anyway) Suggestion: have an environment variable or a PostgreSQL parameter to indicate where to write the temp-table to. This way, you could easily direct it to a RAM disk (if small enough) or to a drive other than your main database. Default could be $TMP. Best regards, Chris _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com