Message-ID: <470A2503.5030107@nekomancer.net>
Date: Mon, 08 Oct 2007 14:39:31 +0200
From: =?ISO-8859-1?Q?G=E1bor_Farkas?= <gabor@nekomancer.net>
User-Agent: Thunderbird 2.0.0.6 (X11/20070924)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: postgresql on NFS.. recommended? not recommended?
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

hi,

is it recommended to run a postgresql server on a nfs-share 
(gigabit-network)? so basically i have a NAS + a database-server,
and wonder if i should put the database on local hard-drives in the 
db-server, or on the NAS, and mount it using NFS on the database-server.

i haven't investigated the issue much yet (checked the 
mailing-list-archives, but couldn't find anything definitive.. ), so 
would like to hear opinions/recommendations?

can the NAS solution be faster? how much is usually the NFS-overhead?

or is there a consensus on this? saying for example "generally, you 
should never use NFS with postgresql?" or it depends on some factors?

intuitively it seems to me that NFS will be always an extra overhead, 
but maybe it's an unmeasurably small overhead?

thanks,
gabor