Thread: best use of another drive
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
On Mon, Sep 8, 2008 at 8:19 PM, Rainer Mager <rainer@vanten.com> 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.
On Mon, 8 Sep 2008 22:11:25 -0600 "Scott Marlowe" <scott.marlowe@gmail.com> wrote: > On Mon, Sep 8, 2008 at 8:19 PM, Rainer Mager <rainer@vanten.com> > 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. > +1 -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
Thanks. I should have mentioned the existing disk and the new one are already both mirrored (not together, though :-p). So we had 2 drives that were mirrored and just added 2 more that are mirrored. --Rainer -----Original Message----- From: Joshua Drake [mailto:jd@commandprompt.com] Sent: Tuesday, 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" <scott.marlowe@gmail.com> wrote: > On Mon, Sep 8, 2008 at 8:19 PM, Rainer Mager <rainer@vanten.com> > 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. > +1 -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
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...