| From: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | [PERFORMANCE] expanding to SAN: which portion best to move |
| Date: | 2011-05-03 15:52:23 |
| Message-ID: | BANLkTimDjFDy8Q8vfDVZ4LBKXb1EjVsh4w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2011-05-03 16:07:50 | Re: [ADMIN] Can we Flush the Postgres Shared Memory ? |
| Previous Message | Raymond O'Donnell | 2011-05-03 15:49:49 | Re: [ADMIN] Can we Flush the Postgres Shared Memory ? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Reymont | 2011-05-03 18:48:35 | amazon ec2 |
| Previous Message | Marc Mamin | 2011-05-03 09:14:01 | Re: Query improvement |