Re: [GENERAL] PostgreSQL over NFS?

[Tom Lane]

Shaw Terwilliger <[EMAIL PROTECTED]> 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