| From: | Fred Moyer <fred(at)redhotpenguin(dot)com> |
|---|---|
| To: | Bill Pennington <bill(at)whitehatsec(dot)com> |
| Cc: | sfpug(at)postgresql(dot)org |
| Subject: | Re: Postgres over SAN/iSCSI |
| Date: | 2008-06-05 17:04:41 |
| Message-ID: | 48481CA9.407@redhotpenguin.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | sfpug |
Bill Pennington wrote:
> Does anyone have experience running Postgres and using an iSCSI SAN as storage? I am looking for options that let me grow storage capacity without downtime while maintaining a reasonable level of performance. iSCSI seems like it might work but I have 0 experience with the technology. Any comments or suggestions are greatly appreciated.
I've run Postgres over DRBD ( http://www.drbd.org )before. It worked,
but the main bottleneck became the I/O limitations in DRBD.
I haven't used iSCSI specifically for Postgres, but have been on the
downtime end of iSCSI SANs quite a bit :) That particular situation was
using NFS over iSCSI, so I can't say assuredly what part of the stack
was the trouble spot.
LVM and data partitioning might be a good option to look at if you are
running Linux.
> ---
> Bill Pennington
> VP Services
> WhiteHat Security Inc.
> http://www.whitehatsec.com
--
Red Hot Penguin Consulting LLC
mod_perl/PostgreSQL consulting and implementation
http://www.redhotpenguin.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | R.P. Aditya | 2008-06-05 17:27:01 | Re: Postgres over SAN/iSCSI |
| Previous Message | Bill Pennington | 2008-06-05 16:33:58 | Postgres over SAN/iSCSI |