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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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