Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0C65964FCE2 for ; Tue, 9 Sep 2008 02:13:19 -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 75715-08 for ; Tue, 9 Sep 2008 02:13:16 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from gv-out-0910.google.com (gv-out-0910.google.com [216.239.58.184]) by postgresql.org (Postfix) with ESMTP id 4BB9E64FCBF for ; Tue, 9 Sep 2008 02:13:16 -0300 (ADT) Received: by gv-out-0910.google.com with SMTP id i36so348863gve.7 for ; Mon, 08 Sep 2008 22:13:14 -0700 (PDT) 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:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=lVLozLLbanM5eyAuwY/ExHny4OduTanAlarM4tWCP+Q=; b=khpHIhC04Y4pGdX5dWkFAzDOlvPgCQZCiW/oRaciZt5nAavST0tkljoDmuTJJevaqV SJKMCPTtcLOOk7xRfXTSb+BTlyjvHgBotSO6RUszMHRf9OfFyt+twuftobBCGPSfvDJB zHd01yscCPgQzXRat3L7UhgzKj25n/Z+GWMi8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=xW3QAaUhe04s5ncuw9xu0N36fWEZt5GeXtc8OBjcqfG9hpBCfAB01sc+wIuehbtuHw iHwDB0JfyOxGKyfwQLVsR7e1KDJWc4ZBqTQipgq6lkDVDDyiXuV0+8DhP9/lCUVV4qr4 IIfGKJA0LrzHeDkEKFCZHJyCfm/EOQ8/G4Bgk= Received: by 10.187.183.15 with SMTP id k15mr2994314fap.86.1220937194562; Mon, 08 Sep 2008 22:13:14 -0700 (PDT) Received: by 10.187.225.11 with HTTP; Mon, 8 Sep 2008 22:13:14 -0700 (PDT) Message-ID: <34d269d40809082213q6359d873h1132ddbf6bfe1baf@mail.gmail.com> Date: Mon, 8 Sep 2008 23:13:14 -0600 From: "Alex Hunsaker" To: "Rainer Mager" Subject: Re: best use of another drive Cc: pgsql-performance@postgresql.org In-Reply-To: <000501c91222$743d9230$5cb8b690$@com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <000501c91222$743d9230$5cb8b690$@com> 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/98 X-Sequence-Number: 31411 On Mon, Sep 8, 2008 at 8:19 PM, Rainer Mager wrote: > 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. What like tablespaces? http://www.postgresql.org/docs/8.3/static/manage-ag-tablespaces.html > > 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. By logs you mean wal logs? Depends on where your bottleneck is.... doing lots of write transactions? Sure this might help...