Re: PG on NFS may be just a bad idea - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: PG on NFS may be just a bad idea
Date
Msg-id 1191915861.4223.601.camel@ebony.site
Whole thread Raw
In response to Re: PG on NFS may be just a bad idea  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Mon, 2007-10-01 at 19:25 -0400, Tom Lane wrote:
> Simon Riggs <simon@2ndquadrant.com> writes:
> > http://blogs.netapp.com/dave/2007/08/oracle-optimize.html
> 
> Not a whole lot of technical content there, but pretty interesting
> nonetheless.  I *think* that the issues we're seeing are largely in the
> NFS client-side kernel code, so bypassing that stack as Oracle is doing
> might eliminate the problem.  Of course, there's a sizable amount of
> code to be written to do that ...

Yeh, that would take a while.

I thought of another reason to do that also.

If you put a tablespace on an NFS mount and the remote server crashes,
it sounds like there could be a window of potential data loss. We could
guard against that by recovering the tablespace, but we don't do that
unless the local server crashes. 

So having your own NFS client would allow you to tell that the link had
dropped and needed to be recovered.

--  Simon Riggs 2ndQuadrant  http://www.2ndQuadrant.com



pgsql-hackers by date:

Previous
From: "Gokulakannan Somasundaram"
Date:
Subject: Re: Including Snapshot Info with Indexes
Next
From: "Gokulakannan Somasundaram"
Date:
Subject: Re: Including Snapshot Info with Indexes