On Mon, 2006-05-22 at 06:15, SODA Noriyuki wrote: Hei > We've encountered failures of "make check", when we put PostgreSQL > data directory on a NFS filesystem or a tmpfs filesystem. > It doesn't always fail, but fails occasionally. > To have a database on a NFS filesystem is a disaster waiting to happen, specially if the NFS server is running on Linux. Not to talk on the performance penalty of running the database via NFS. I would say that anything is better than NFS for running a database. But if you absolutely have to use NFS, run NFS via TCP not UDP, use hard and turn off all cache ..... In the server side we are talking about 'sync' and 'no_wdelay' parameters and in the client about 'bg','hard','intr','noac' and 'tcp', probably the throughput will improve by increasing rsize and wsize to 16384 or even 32768. regards, -- Rafael Martinez, <r.m.guerrero@xxxxxxxxxxx> Center for Information Technology Services University of Oslo, Norway PGP Public Key: http://folk.uio.no/rafael/
