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

Re: FW: Queries becoming slow under heavy load

From: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
To: "sthomas(at)peak6(dot)com" <sthomas(at)peak6(dot)com>
Cc: Anne Rosset <arosset(at)collab(dot)net>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: FW: Queries becoming slow under heavy load
Date: 2011-01-28 18:46:09
Message-ID: 4D430EF1.8000800@vmsinfo.com (view raw or flat)
Thread:
Lists: pgsql-performance
Shaun Thomas wrote:
> On 01/27/2011 11:12 PM, Anne Rosset wrote:
>
>   
>> Thanks for your response.
>> We are over NFS for our storage ...
>>     
>
> NFS? I'm not sure you know this, but NFS has major locking issues
> that would make it a terrible candidate for hosting a database.
>
>   
That depends on the implementation. Vendor supported NAS, running NFS3 
or NFS4 should be OK. There are other databases that can use it, too. 
Some databases even have a built-in NFS client.

-- 
 
Mladen Gogala 
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com 
The Leader in Integrated Media Intelligence Solutions




In response to

pgsql-performance by date

Next:From: Scott MarloweDate: 2011-01-28 18:55:10
Subject: Re: How to best use 32 15k.7 300GB drives?
Previous:From: Scott CareyDate: 2011-01-28 17:50:47
Subject: Re: How to best use 32 15k.7 300GB drives?

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