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 BE580D1D767 for ; Sat, 24 Jan 2004 01:23:21 +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 15674-10 for ; Fri, 23 Jan 2004 21:22:53 -0400 (AST) Received: from smtp.k12us.com (smtp.k12us.com [65.112.222.15]) by svr1.postgresql.org (Postfix) with SMTP id 76B36D1D561 for ; Fri, 23 Jan 2004 21:22:49 -0400 (AST) Received: (qmail 41584 invoked by uid 1001); 24 Jan 2004 01:22:47 -0000 Date: Fri, 23 Jan 2004 20:22:47 -0500 From: Christopher Weimann To: "Joshua D. Drake" Cc: Andrew Sullivan , pgsql-performance@postgresql.org Subject: Re: High Performance/High Reliability File system on SuSE64 Message-ID: <20040124012247.GA40439@smtp.k12us.com> References: <001001c3e1d0$072b20e0$6601a8c0@thore> <401150F7.1040802@commandprompt.com> <20040123175544.GA12642@phlogiston.dyndns.org> <4011657B.2090501@commandprompt.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4011657B.2090501@commandprompt.com> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/337 X-Sequence-Number: 5511 On 01/23/2004-10:18AM, Joshua D. Drake wrote: > > 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. 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.