From: Frits Hoogland <frits.hoogland@gmail.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: Chris Hoover <revoohc@gmail.com>
Cc: PGSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: PostgreSQL NetApp and NFS
Date: Thu, 20 Mar 2008 22:23:30 +0100
Message-ID: <fbb8fbcd0803201423h27df25d5v5801f77f2a0e4031@mail.gmail.com> (raw)
In-Reply-To: <200803202009.m2KK9dc26453@momjian.us>
References: <1d219a6f0803201232g54924fb3ka206c9b03e4664c7@mail.gmail.com>
<200803202009.m2KK9dc26453@momjian.us>
My experience postgresql work good on NFS. Of course, use NFS over TCP, and
use noac if you want to protect your database even more (my experience is
NFS client caching doesn't lead to an irrecoverable database however)
I've encountered problems with RHEL4 as a database server and a client of a
Netapp filer, due to a bug in the (redhat nfs client)
Postgresql uses BSD read/write semantics. The BSD semantics mean an IO call
(either read or write) is atomic.
Linux uses system V read/write semantics. The system V semantics mean an IO
is NOT atomic and can be interrupted.
A read call got interrupted (due to the bug in the nfs client), which meant
the IO call kept waiting until infinity.
It even caused all other IO done against the inode to be waiting, leading to
a situation where the server needed a reboot to be able to function
propertly.
frits
On Thu, Mar 20, 2008 at 9:09 PM, Bruce Momjian <bruce@momjian.us> wrote:
> Chris Hoover wrote:
> > If you have any real life good or bad stories, I'd love to hear it.
> Given
> > the NetApp arrays supposedly being very good NFS platforms, overall, is
> this
> > a recommended way to run PostgreSQL, or is it recommended to not run
> this
> > way.
>
> We do have an NFS section in our documentation at the bottom of this
> page:
>
> http://www.postgresql.org/docs/8.3/static/creating-cluster.html
>
> --
> Bruce Momjian <bruce@momjian.us> http://momjian.us
> EnterpriseDB http://postgres.enterprisedb.com
>
> + If your life is a hard drive, Christ can be your backup. +
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
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-performance@postgresql.org
Cc: frits.hoogland@gmail.com, bruce@momjian.us, revoohc@gmail.com
Subject: Re: PostgreSQL NetApp and NFS
In-Reply-To: <fbb8fbcd0803201423h27df25d5v5801f77f2a0e4031@mail.gmail.com>
* 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