postgresql on NFS.. recommended? not recommended?

From: Gábor Farkas <gabor(at)nekomancer(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: postgresql on NFS.. recommended? not recommended?
Date: 2007-10-08 12:39:31
Message-ID: 470A2503.5030107@nekomancer.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Tolley 2007-10-08 13:43:42 Re: postgresql on NFS.. recommended? not recommended?
Previous Message Magnus Hagander 2007-10-08 06:12:10 Re: Apache2 PostgreSQL http authentication