pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Simon Riggs <simon@2ndquadrant.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-hackers@postgresql.org, Mija Lee <mija@scharp.org>
Subject: Re: PG on NFS may be just a bad idea
Date: Tue, 09 Oct 2007 08:44:21 +0100
Message-ID: <1191915861.4223.601.camel@ebony.site> (raw)
In-Reply-To: <24184.1191281116@sss.pgh.pa.us>
References: <25517.1191038302@sss.pgh.pa.us>
	<47012AC5.9040808@agliodbs.com>
	<1191263814.4260.57.camel@ebony.site>
	<1191264888.4260.69.camel@ebony.site>
	<24184.1191281116@sss.pgh.pa.us>

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




view thread (13+ messages)  latest in thread

Message-ID: <1191915861.4223.601.camel@ebony.site>
Permalink:  ../1191915861.4223.601.camel@ebony.site/
Also on:    postgresql.org/message-id/1191915861.4223.601.camel@ebony.site

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: simon@2ndquadrant.com, tgl@sss.pgh.pa.us, josh@agliodbs.com, mija@scharp.org
  Subject: Re: PG on NFS may be just a bad idea
  In-Reply-To: <1191915861.4223.601.camel@ebony.site>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox