Re: PostgreSQL, NetBSD and NFS

From: Curt Sampson <cjs(at)cynic(dot)net>
To: mlw <pgsql(at)mohawksoft(dot)com>
Cc: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>, pgsql-hackers(at)postgresql(dot)org, current-users(at)netbsd(dot)org
Subject: Re: PostgreSQL, NetBSD and NFS
Date: 2003-02-01 06:24:15
Message-ID: Pine.NEB.4.51.0302011521390.610@angelic.cynic.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)cynic(dot)net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Copeland 2003-02-01 06:27:31 Re: Win32 port powerfail testing
Previous Message Greg Copeland 2003-02-01 06:18:19 Re: [mail] Re: Windows Build System