Re: PostgreSQL, NetBSD and NFS - Mailing list pgsql-hackers

From Curt Sampson
Subject Re: PostgreSQL, NetBSD and NFS
Date
Msg-id Pine.NEB.4.51.0302011521390.610@angelic.cynic.net
Whole thread Raw
In response to Re: PostgreSQL, NetBSD and NFS  (mlw <pgsql@mohawksoft.com>)
List pgsql-hackers
On Fri, 31 Jan 2003, mlw wrote:

> . There are always issues with file locking across various
> platforms. I recall reading about mmap issues across NFS a while ago...

Postgres uses neither of these, IIRC, so that should be fine. (Actually,
postgres does effectively use mmap for shared memory on NetBSD, but
that's not mapping data on the NFS filesystem, so it's not an issue.)

> The NFS client may also have isses with locking, fsync, and mmap.

Any fsync problems would affect data integrity during a crash, but
nothing otherwise.

(Of course, I'm happy to be corrected on any of these issues, if someone
can point out particular parts of postgres that would fail over NFS.)

cjs
-- 
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org   Don't you know, in this new Dark Age, we're
alllight.  --XTC
 


pgsql-hackers by date:

Previous
From: Curt Sampson
Date:
Subject: Re: On file locking
Next
From: Curt Sampson
Date:
Subject: Re: [mail] Re: Windows Build System