Re: PostgreSQL over NFS? - Mailing list pgsql-general

From Tom Lane
Subject Re: PostgreSQL over NFS?
Date
Msg-id 29844.981761407@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL over NFS?  (Shaw Terwilliger <sterwill@sourcegear.com>)
Responses Re: PostgreSQL over NFS?  (Alfred Perlstein <bright@wintelcom.net>)
List pgsql-general
Shaw Terwilliger <sterwill@sourcegear.com> writes:
> I have a client who wants to know how PostgreSQL (7) will perform over
> NFS.  The NFS client is Solaris, the server is a big network storage=20
> appliance.  The network is probably gigabit ethernet.

> My first reaction is to tell them they're just crazy,

I agree.

Aside from the speed issues, there's a serious reliability problem;
AFAIR, NFS doesn't guarantee very much about write ordering, which
means a crash could leave you with corrupt data.

Seems a lot better to run the Postgres server on the machine where
the storage is.

            regards, tom lane

pgsql-general by date:

Previous
From: Alfred Perlstein
Date:
Subject: Re: PostgreSQL over NFS?
Next
From: "Steve Wolfe"
Date:
Subject: Re: PostgreSQL over NFS?