X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2F590D1E7D1 for ; Fri, 23 Jan 2004 18:19:22 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 15520-03 for ; Fri, 23 Jan 2004 14:18:51 -0400 (AST) Received: from hosting.commandprompt.com (215.commandprompt.com [207.173.200.215]) by svr1.postgresql.org (Postfix) with ESMTP id 24BC3D1E84A for ; Fri, 23 Jan 2004 14:18:48 -0400 (AST) Received: from commandprompt.com (dsl093-038-087.pdx1.dsl.speakeasy.net [66.93.38.87]) (authenticated) by hosting.commandprompt.com (8.11.6/8.11.6) with ESMTP id i0NIIfm24844; Fri, 23 Jan 2004 10:18:41 -0800 Message-ID: <4011657B.2090501@commandprompt.com> Date: Fri, 23 Jan 2004 10:18:35 -0800 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Andrew Sullivan Cc: pgsql-performance@postgresql.org Subject: Re: High Performance/High Reliability File system on SuSE64 References: <001001c3e1d0$072b20e0$6601a8c0@thore> <401150F7.1040802@commandprompt.com> <20040123175544.GA12642@phlogiston.dyndns.org> In-Reply-To: <20040123175544.GA12642@phlogiston.dyndns.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/240 X-Sequence-Number: 5414 >>XFS.. hands down. >> >> > >I thought it was you who recently said you thought there was some >sort of possible caching problem there? > > > Not I. We have had issues with JFS and data corruption on a powerout but XFS has been rock solid in all of our tests. XFS also has the interesting ability (although I have yet to test it) that will allow you to take a snapshot of the filesystem. Thus you can have filesystem level backups of the PGDATA directory that are consistent even though the database is running. There is nothing else on Linux that comes close to that. Plus XFS has been proven in a 64 bit environment (Irix). Sincerely, Joshua D. Drake >A > > > -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL