Data on NAS / NFS

From: Jean-Denis Girard <jd(dot)girard(at)sysnux(dot)pf>
To: pgsql-general(at)postgresql(dot)org
Subject: Data on NAS / NFS
Date: 2007-07-28 04:48:14
Message-ID: 46AACA8E.2050308@sysnux.pf
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi list,

I'm looking for advices / experiences concerning PostgreSQL with data
storage on NAS via NFS. I've found a few references in the archives or
the docs, but they are old, and opinions differ:
. "There are a lot of horror stories concerning running databases (not
only Postgres) over NFS."
http://archives.postgresql.org/pgsql-performance/2004-06/msg00217.php
. "NFS and other remote file systems are not recommended for use by
POSTGRESQL. NFS does not have the same file system semantics as a local
file system, and these inconsistencies can cause data reliability or
crash recovery problems."
http://www.postgresql.org/files/documentation/books/aw_pgsql/hw_performance/node11.html
. "The problem with NFS is not so much the protocol, but whether your
server is reliable. If you trust that your NAS device is reliable
enough, then you should be OK."
http://archives.postgresql.org/pgsql-general/2005-11/msg01362.php

The NAS would be from LaCie, using 4 disks (Raid5 + spare)
(http://www.lacie.com/fr/products/product.htm?pid=10876), mounted via
NFS from a Linux server running Postgresql .

What are the implications with regard to PostgreSQL performance and
(more important) reliability?

Thanks in advance.
Regards,
--
Jean-Denis Girard

SysNux Systèmes Linux en Polynésie française
http://www.sysnux.pf/ Tél: +689 483 527 / GSM: +689 797 527

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2007-07-28 16:50:58 European users mailing list
Previous Message Mitchell Vincent 2007-07-28 03:26:58 The leanest, meanest Windows installer possible