Skip site navigation (1) Skip section navigation (2)

Re: Anyone using a SAN?

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: (view raw, whole thread or download thread mbox)
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


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.


In response to


pgsql-performance by date

Next:From: Thomas ZaksekDate: 2008-02-13 17:46:51
Subject: Re: Join Query Perfomance Issue
Previous:From: Greg SmithDate: 2008-02-13 17:38:28
Subject: Re: Small DB Server Advice

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group