Re: [PERFORM] best use of another drive

2008-09-08 Thread Alex Hunsaker
On Mon, Sep 8, 2008 at 8:19 PM, Rainer Mager <[EMAIL PROTECTED]> 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?

Re: [PERFORM] best use of another drive

2008-09-08 Thread Rainer Mager
, September 09, 2008 1:16 PM To: Scott Marlowe Cc: Rainer Mager; pgsql-performance@postgresql.org Subject: Re: [PERFORM] best use of another drive On Mon, 8 Sep 2008 22:11:25 -0600 "Scott Marlowe" <[EMAIL PROTECTED]> wrote: > On Mon, Sep 8, 2008 at 8:19 PM, Rainer Mager <[EMA

Re: [PERFORM] best use of another drive

2008-09-08 Thread Joshua Drake
On Mon, 8 Sep 2008 22:11:25 -0600 "Scott Marlowe" <[EMAIL PROTECTED]> wrote: > On Mon, Sep 8, 2008 at 8:19 PM, Rainer Mager <[EMAIL PROTECTED]> > wrote: > > 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: > > Being

Re: [PERFORM] best use of another drive

2008-09-08 Thread Scott Marlowe
On Mon, Sep 8, 2008 at 8:19 PM, Rainer Mager <[EMAIL PROTECTED]> wrote: > 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: Being a DBA, I'd tend to say make it a mirror of the first drive. -- Sent via pgsql-performanc

[PERFORM] best use of another drive

2008-09-08 Thread Rainer Mager
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 t