pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedbest use of another drive
5+ messages / 4 participants
[nested] [flat]
* best use of another drive
@ 2008-09-09 02:19 Rainer Mager <rainer@vanten.com>
2008-09-09 04:11 ` Re: best use of another drive Scott Marlowe <scott.marlowe@gmail.com>
2008-09-09 05:13 ` Re: best use of another drive Alex Hunsaker <badalex@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Rainer Mager @ 2008-09-09 02:19 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: best use of another drive
2008-09-09 02:19 best use of another drive Rainer Mager <rainer@vanten.com>
@ 2008-09-09 04:11 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-09-09 04:16 ` Re: best use of another drive Joshua Drake <jd@commandprompt.com>
1 sibling, 1 reply; 5+ messages in thread
From: Scott Marlowe @ 2008-09-09 04:11 UTC (permalink / raw)
To: Rainer Mager <rainer@vanten.com>; +Cc: pgsql-performance
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: best use of another drive
2008-09-09 02:19 best use of another drive Rainer Mager <rainer@vanten.com>
2008-09-09 04:11 ` Re: best use of another drive Scott Marlowe <scott.marlowe@gmail.com>
@ 2008-09-09 04:16 ` Joshua Drake <jd@commandprompt.com>
2008-09-09 04:35 ` Re: best use of another drive Rainer Mager <rainer@vanten.com>
0 siblings, 1 reply; 5+ messages in thread
From: Joshua Drake @ 2008-09-09 04:16 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: Rainer Mager <rainer@vanten.com>; pgsql-performance
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: best use of another drive
2008-09-09 02:19 best use of another drive Rainer Mager <rainer@vanten.com>
2008-09-09 04:11 ` Re: best use of another drive Scott Marlowe <scott.marlowe@gmail.com>
2008-09-09 04:16 ` Re: best use of another drive Joshua Drake <jd@commandprompt.com>
@ 2008-09-09 04:35 ` Rainer Mager <rainer@vanten.com>
0 siblings, 0 replies; 5+ messages in thread
From: Rainer Mager @ 2008-09-09 04:35 UTC (permalink / raw)
To: 'Joshua Drake' <jd@commandprompt.com>; 'Scott Marlowe' <scott.marlowe@gmail.com>; +Cc: 'Rainer Mager' <rainer@vanten.com>; pgsql-performance
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: best use of another drive
2008-09-09 02:19 best use of another drive Rainer Mager <rainer@vanten.com>
@ 2008-09-09 05:13 ` Alex Hunsaker <badalex@gmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Alex Hunsaker @ 2008-09-09 05:13 UTC (permalink / raw)
To: Rainer Mager <rainer@vanten.com>; +Cc: 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...
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2008-09-09 05:13 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-09-09 02:19 best use of another drive Rainer Mager <rainer@vanten.com>
2008-09-09 04:11 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-09-09 04:16 ` Joshua Drake <jd@commandprompt.com>
2008-09-09 04:35 ` Rainer Mager <rainer@vanten.com>
2008-09-09 05:13 ` Alex Hunsaker <badalex@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox