Re: best use of another drive - Mailing list pgsql-performance

From Alex Hunsaker
Subject Re: best use of another drive
Date
Msg-id 34d269d40809082213q6359d873h1132ddbf6bfe1baf@mail.gmail.com
Whole thread Raw
In response to best use of another drive  ("Rainer Mager" <rainer@vanten.com>)
List pgsql-performance
On Mon, Sep 8, 2008 at 8:19 PM, Rainer Mager <rainer@vanten.com> 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...

pgsql-performance by date:

Previous
From: "Rainer Mager"
Date:
Subject: Re: best use of another drive
Next
From: "Matt Smiley"
Date:
Subject: Re: too many clog files