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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026