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: 20080213174647.GK12156@it.is.rice.edu (view raw or flat)
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

In response to

Responses

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-2014 The PostgreSQL Global Development Group