Re: PG on NFS may be just a bad idea

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgreSQL(dot)org, pgsql-novice(at)postgreSQL(dot)org, Mija Lee <mija(at)scharp(dot)org>
Subject: Re: PG on NFS may be just a bad idea
Date: 2007-10-01 18:36:54
Message-ID: 1191263814.4260.57.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers pgsql-novice

On Mon, 2007-10-01 at 10:13 -0700, Josh Berkus wrote:

> > Maybe we need to actively discourage people from running Postgres
> > against NFS-mounted data directories. Shane Kerr's paper cited above
> > mentions some other rather scary properties, including O_EXCL file
> > creation not really working properly.
>
> Wouldn't you be describing a Linux-specific issue, though? And possibly
> kernel-specific?

Possibly, though if you have any specific refutations of the Kerr paper
then it would be a good idea to air them. It isn't enough to just hint
some exist.

> It's hard to reconcile this with the real-world performance of
> PostgreSQL on NFS, which is happening all over the place. Most notably,
> Joe Conway's 20,000 txn/sec.
>
> I *do* think it's an accurate statement that if you're going to use
> Postgres, or any other OLTP database, on NFS you'd better have access to
> a NAS expert. But to say that it's a bad idea even if you have expert
> help is probably going to far.

I can see many papers on database performance on NFS, but I don't see
any discussion of potential reliability concerns. If anybody sits near
an NAS expert, it would be great to have that discussion.

I have found some comments that other databases require "specific
configuration settings to ensure efficient and correct usage" of NFS "to
access NAS storage devices".

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

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Simon Riggs 2007-10-01 18:54:48 Re: PG on NFS may be just a bad idea
Previous Message Tom Lane 2007-10-01 17:24:41 Re: [HACKERS] PG on NFS may be just a bad idea

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2007-10-01 18:54:48 Re: PG on NFS may be just a bad idea
Previous Message Chuck McDevitt 2007-10-01 18:18:56 Re: IDE

Browse pgsql-novice by date

  From Date Subject
Next Message Simon Riggs 2007-10-01 18:54:48 Re: PG on NFS may be just a bad idea
Previous Message Tom Lane 2007-10-01 18:09:47 Re: DST question