| From: | Kenneth Marshall <ktm(at)rice(dot)edu> |
|---|---|
| To: | Peter Koczan <pjkoczan(at)gmail(dot)com> |
| Cc: | pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Anyone using a SAN? |
| Date: | 2008-02-13 17:46:47 |
| Message-ID: | 20080213174647.GK12156@it.is.rice.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, Feb 13, 2008 at 10:56:54AM -0600, Peter Koczan wrote:
> Hi all,
>
> We're considering setting up a SAN where I work. Is there anyone using
> a SAN, for postgres or other purposes? If so I have a few questions
> for you.
>
> - Are there any vendors to avoid or ones that are particularly good?
>
> - What performance or reliability implications exist when using SANs?
>
> - Are there any killer features with SANs compared to local storage?
>
> Any other comments are certainly welcome.
>
> Peter
>
Peter,
The key is to understand your usage patterns, both I/O and query.
SANs can be easily bandwidth limited which can tank your database
performance. There have been several threads in the mailing list
about performance problems caused by the use of a SAN for storage.
Cheers,
Ken
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Zaksek | 2008-02-13 17:46:51 | Re: Join Query Perfomance Issue |
| Previous Message | Greg Smith | 2008-02-13 17:38:28 | Re: Small DB Server Advice |