Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9C325650000 for ; Mon, 8 Sep 2008 23:20:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 45125-09 for ; Mon, 8 Sep 2008 23:19:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ichigo.office.vanten.com (static-222-230-136-226.b-fam.svips.gol.ne.jp [222.230.136.226]) by postgresql.org (Postfix) with ESMTP id 16F0864FD27 for ; Mon, 8 Sep 2008 23:19:57 -0300 (ADT) Received: from rainerxp (rainer-xp.office.vanten.com [192.168.220.186]) by ichigo.office.vanten.com (Postfix) with ESMTP id ADD405081C for ; Tue, 9 Sep 2008 11:19:31 +0900 (JST) From: "Rainer Mager" To: Subject: best use of another drive Date: Tue, 9 Sep 2008 11:19:14 +0900 Message-ID: <000501c91222$743d9230$5cb8b690$@com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AckSInM+bI7p/Df9R1a0Tj9eCShxaQ== Content-Language: en-us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/94 X-Sequence-Number: 31407 I've recently installed another drive in my db server and was wondering what the best use of it is. Some thoughts I have are: 1. Move some of the databases to the new drive. If this is a good idea, is there a way to do this without a dump/restore? I'd prefer to move the folder if possible since that would be much faster. 2. Move some logs to the new drive. Again, if this is recommended I'd be happy to, but some directions on the right procedures would be appreciated. 3. Other...any other ideas? Thanks, --Rainer