Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id ADED51337B5A for ; Wed, 1 Dec 2010 17:31:47 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 41264-06 for ; Wed, 1 Dec 2010 21:31:41 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 5949A133740B for ; Wed, 1 Dec 2010 17:31:40 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id oB1LVaBU021815; Wed, 1 Dec 2010 16:31:36 -0500 (EST) To: Lou Picciano cc: pgsql-admin , Craig James Subject: Re: Best Linux filesystem for Postgres data store ? In-reply-to: <1733344795.31985.1291228116345.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> References: <1733344795.31985.1291228116345.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> Comments: In-reply-to Lou Picciano message dated "Wed, 01 Dec 2010 18:28:36 +0000" Date: Wed, 01 Dec 2010 16:31:36 -0500 Message-ID: <21814.1291239096@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/10 X-Sequence-Number: 36239 Lou Picciano writes: > We use ZFS on Solaris for our data stores. Can't beat ZFS for its failsafe features, filesystem portability, etc. > Having said that, there is that school of thought which would hold that journaling may not be all that indicated anymore, given the quality of recovery possible from the binary logs. In fact, this would suggest that journaling may even be counterproductive - effectively redundant - in a transaction-heavy environment. Well, the conventional wisdom is that you want metadata journaling, but *not* data journaling, at the filesystem level. Postgres can protect its data just fine, but it can't recover if the filesystem goes insane. regards, tom lane