Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 30B2D9FA19C for ; Mon, 1 Oct 2007 15:55:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 10706-07-3 for ; Mon, 1 Oct 2007 15:55:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from outmail136093.authsmtp.net (outmail136093.authsmtp.net [62.13.136.93]) by postgresql.org (Postfix) with ESMTP id 4CCF49FA1FE for ; Mon, 1 Oct 2007 15:55:14 -0300 (ADT) Received: from outmail128180.authsmtp.com (outmail128180.authsmtp.com [62.13.128.180]) by punt2.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l91IskSW029038; Mon, 1 Oct 2007 19:54:46 +0100 (BST) Received: from [192.168.0.3] (85-211-149-22.dyn.gotadsl.co.uk [85.211.149.22]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l91IsjLX049079; Mon, 1 Oct 2007 19:54:45 +0100 (BST) Subject: Re: PG on NFS may be just a bad idea From: Simon Riggs To: Josh Berkus Cc: Tom Lane , pgsql-hackers@postgreSQL.org, Mija Lee In-Reply-To: <1191263814.4260.57.camel@ebony.site> References: <25517.1191038302@sss.pgh.pa.us> <47012AC5.9040808@agliodbs.com> <1191263814.4260.57.camel@ebony.site> Content-Type: text/plain Date: Mon, 01 Oct 2007 19:54:48 +0100 Message-Id: <1191264888.4260.69.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Server-Quench: c74557fb-704f-11dc-b86a-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksachtFaARbYlpF HGQLW1NEUVR7XGd/ bwwfZQBDYEtPQQRu WVZLQE1QERpoT0AI B2ddCGUadwFPeHl5 K0dgXXAVD0N+cEN6 FBxJEm0CM3phaTRM TRJQcVJJcANLfxdA PlN4UyBcLwdSbGoL PyYYHB0LBgAXEAsd RQdFC3wpCUMCD3Y2 SlgAAC4zVURNTSw/ Zx0qJ1d0 X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:752/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/29 X-Sequence-Number: 108397 On Mon, 2007-10-01 at 19:36 +0100, Simon Riggs wrote: > > I *do* think it's an accurate statement that if you're going to use > > Postgres, or any other OLTP database, on NFS you'd better have access to > > a NAS expert. But to say that it's a bad idea even if you have expert > > help is probably going to far. > > I can see many papers on database performance on NFS, but I don't see > any discussion of potential reliability concerns. If anybody sits near > an NAS expert, it would be great to have that discussion. http://blogs.netapp.com/dave/2007/08/oracle-optimize.html -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com