From: Willy-Bas Loos <willybas@gmail.com>
To: pgsql-performance@postgresql.org
Subject: [PERFORMANCE] expanding to SAN: which portion best to move
Date: Tue, 3 May 2011 17:52:23 +0200
Message-ID: <BANLkTimDjFDy8Q8vfDVZ4LBKXb1EjVsh4w@mail.gmail.com> (raw)
Hi,
Our database has gotten rather large and we are running out of disk space.
our disks are 15K rpm SAS disks in RAID 10.
We are going to rent some space on a FibreChannel SAN.
That gives us the opportunity to separate the data and the indexes.
Now i thought it would be best to move the indexes to the SAN and leave the
data on the disks, since the disks are better at sequential I/O and the SAN
will have lots of random I/O since there are lots of users on it.
Is that a wise thing to do?
Cheers,
WBL
--
"Patriotism is the conviction that your country is superior to all others
because you were born in it." -- George Bernard Shaw
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: willybas@gmail.com
Subject: Re: [PERFORMANCE] expanding to SAN: which portion best to move
In-Reply-To: <BANLkTimDjFDy8Q8vfDVZ4LBKXb1EjVsh4w@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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