Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 7FAF82E0042 for ; Mon, 18 Feb 2008 11:27:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 80181-05 for ; Mon, 18 Feb 2008 11:27:33 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.180]) by postgresql.org (Postfix) with ESMTP id 72ABA2E0048 for ; Mon, 18 Feb 2008 11:27:41 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so3578436waf.5 for ; Mon, 18 Feb 2008 07:27:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=r2GGUavHPq6XSQluwhmeAvKS7F/GKV/dShVk/WHPvVM=; b=Uv4/JWL1pFew0X3A/KvAGvphQQLpAHzztzbUDGVqme7sCTEIcN68f+ArQMoJEyMVQIAZIS6zJgu0IZJME8NjuOlvEk3PkMvZBRUqpTgkSCkfHfQOLlIYC0xFH73IPKTw7UphgASo0f4SdyHqQqCt7E9k6iYdwxIF0PmQ8Edoin8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=olCsTf3F8875ckWwoisGNxg8wCIKTD1I2qX3P8CgaDejapHm9H8FRaZxXRNnclde38R/eH84Y3zqOYUYpbC3aj+kspO51ND4OvowTVikV57a9Wi7l7WR2G2PXopM1SGJA/RYI1i/tPhK/yguODbvNEupj0YGi3XEFtOvSGrN7DM= Received: by 10.114.124.1 with SMTP id w1mr1117682wac.131.1203348459976; Mon, 18 Feb 2008 07:27:39 -0800 (PST) Received: by 10.114.38.1 with HTTP; Mon, 18 Feb 2008 07:27:39 -0800 (PST) Message-ID: Date: Mon, 18 Feb 2008 10:27:39 -0500 From: "Nikolas Everett" To: pgsql-performance@postgresql.org Subject: Controling where temporary files are created MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_16684_7473873.1203348459966" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200802/202 X-Sequence-Number: 28744 ------=_Part_16684_7473873.1203348459966 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Is there a way I can change where postgres writes it temporary files? My data directory is on a slow array, but we also have a fast array. I'm looking to get all the temp file creation onto the fast array. ------=_Part_16684_7473873.1203348459966 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Is there a way I can change where postgres writes it temporary files?  My data directory is on a slow array, but we also have a fast array.  I'm looking to get all the temp file creation onto the fast array.
------=_Part_16684_7473873.1203348459966--