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

Re: [HACKERS] PG on NFS may be just a bad idea

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org, pgsql-novice(at)postgreSQL(dot)org, Mija Lee <mija(at)scharp(dot)org>
Subject: Re: [HACKERS] PG on NFS may be just a bad idea
Date: 2007-10-01 17:13:41
Message-ID: 47012AC5.9040808@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-docspgsql-hackerspgsql-novice
Tom,

> 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?

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.

--Josh Berkus

In response to

Responses

pgsql-novice by date

Next:From: Wright, GeorgeDate: 2007-10-01 17:19:47
Subject: DST question
Previous:From: Nis JørgensenDate: 2007-10-01 10:19:05
Subject: Re: Why is my view ddl being altered by postgres?

pgsql-docs by date

Next:From: Tom LaneDate: 2007-10-01 17:24:41
Subject: Re: [HACKERS] PG on NFS may be just a bad idea
Previous:From: Zdenek KotalaDate: 2007-09-29 14:23:59
Subject: Re: PG on NFS may be just a bad idea

pgsql-hackers by date

Next:From: Gregory StarkDate: 2007-10-01 17:15:08
Subject: Re: First steps with 8.3 and autovacuum launcher
Previous:From: Alvaro HerreraDate: 2007-10-01 17:06:58
Subject: Re: Enforcing database encoding and locale match

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