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