Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 306819FB1EB for ; Mon, 1 Oct 2007 14:28:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 80248-01-6 for ; Mon, 1 Oct 2007 14:28:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id C9B319FB737 for ; Mon, 1 Oct 2007 14:24:45 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l91HOfaw018215; Mon, 1 Oct 2007 13:24:41 -0400 (EDT) To: Josh Berkus cc: pgsql-hackers@postgreSQL.org, pgsql-novice@postgreSQL.org, Mija Lee Subject: Re: [HACKERS] PG on NFS may be just a bad idea In-reply-to: <47012AC5.9040808@agliodbs.com> References: <25517.1191038302@sss.pgh.pa.us> <47012AC5.9040808@agliodbs.com> Comments: In-reply-to Josh Berkus message dated "Mon, 01 Oct 2007 10:13:41 -0700" Date: Mon, 01 Oct 2007 13:24:41 -0400 Message-ID: <18214.1191259481@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/4 X-Sequence-Number: 19456 Josh Berkus writes: >> Maybe we need to actively discourage people from running Postgres >> against NFS-mounted data directories. > It's hard to reconcile this with the real-world performance of > PostgreSQL on NFS, which is happening all over the place. Most notably, > Joe Conway's 20,000 txn/sec. This is not a question of performance, it is a question of whether you are willing to tolerate corner-case misbehaviors. regards, tom lane