Re: PostgreSQL over NFS?

> It is not performance I would be concerned about, but reliability.  NFS
> has no state for reliability.  I have to ask why they are using NFS
> rather than putting it on a drive local to the machine.  If they say
> they want to share the data between two machines, that is even crazier.

  They may want to put the data on a file server, so that it gets backed up,
and has the advantage of a hardware fault-tolerant RAID array.  Tht has it's
merits, but I don't think it woul dbe that great for performance.  We spent
the money to put another RAID array in the database machine, both for
reliability and speed.  Once per night, the DB is dumped, and the dump is
copied to the file server, so that we have a second copy somewhere, and it's
included in the nightly tape backup.

steve