Re: PostgreSQL over NFS?

-- Start of PGP signed section.
> I've been using PostgreSQL for a few years now in various projects, and
> I've been very happy with its features and performance.
>
> 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
> appliance.  The network is probably gigabit ethernet.
>
> My first reaction is to tell them they're just crazy, and that's not how
> a database is intended to work, and they should buy some fast, redundant
> local storage.   I thought I'd ask the designers and users here so I could
> back up my recommendations.

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.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026