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 C7CA3D1D643 for ; Sat, 24 Jan 2004 01:27:25 +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 29137-08 for ; Fri, 23 Jan 2004 21:26:58 -0400 (AST) Received: from hosting.commandprompt.com (215.commandprompt.com [207.173.200.215]) by svr1.postgresql.org (Postfix) with ESMTP id 7B46DD1D575 for ; Fri, 23 Jan 2004 21:26:54 -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 i0O1Qom32663; Fri, 23 Jan 2004 17:26:51 -0800 Message-ID: <4011C9D5.6050905@commandprompt.com> Date: Fri, 23 Jan 2004 17:26:45 -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: Christopher Weimann Cc: Andrew Sullivan , 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> <4011657B.2090501@commandprompt.com> <20040124012247.GA40439@smtp.k12us.com> In-Reply-To: <20040124012247.GA40439@smtp.k12us.com> 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/251 X-Sequence-Number: 5425 >You can do snapshots in FreeBSD 5.x with UFS2 as well but that ( >nor XFS snapshots ) will let you backup with the database server >running. Just because you will get the file exactly as it was at >a particular instant does not mean that the postmaster did not >still have some some data that was not flushed to disk yet. > > Ahh... isn't that what fsync is for? -- 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