Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4FFC064FC22 for ; Wed, 24 Sep 2008 07:39:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 73275-09 for ; Wed, 24 Sep 2008 07:39:25 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.158]) by postgresql.org (Postfix) with ESMTP id 5E85564FC21 for ; Wed, 24 Sep 2008 07:39:25 -0300 (ADT) Received: by fg-out-1718.google.com with SMTP id 16so2215366fgg.23 for ; Wed, 24 Sep 2008 03:39:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=mG0ts5X8PiYZwRNswnN0buVdkJz67ncDTRSYl6OAecA=; b=JFgzFtB8kwnMA80okH6RJl77CVqUm7MI329bm9cdssdSHkuVvispR5LBYOdzMpB3ps QjCuoxV9a8zyXKn8Y2M/V2MMhoZXMPYGCN8y+dhTs5fGc8K3ZetrFL/Jfc8b5e9QsqXp 9uFFXW1D6hCmFfHUvM7Y+1fuW1js3uC4yqeK8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=hdMJL6S15GvcCahhWA/AGDfSylqVCdSRnJnrtuFBbnNpI80lBoVkb/zHJXTt5FSTnA /Fs1LpG8Wo4BK1NOk+eKOffT0izSGe+GRJ9Msybw2J+vBEq4ZInce/lQjZ0jgV7yktgT krUmpFcSHmZyOJc/MgXBpVcizOItMT1Nzjslk= Received: by 10.86.27.19 with SMTP id a19mr7205476fga.37.1222252763715; Wed, 24 Sep 2008 03:39:23 -0700 (PDT) Received: by 10.86.79.10 with HTTP; Wed, 24 Sep 2008 03:39:23 -0700 (PDT) Message-ID: Date: Wed, 24 Sep 2008 12:39:23 +0200 From: "Claus Guttesen" To: "Laszlo Nagy" Subject: Re: UFS 2: soft updates vs. gjournal (AKA: Choosing a filesystem 2.) Cc: pgsql-performance@postgresql.org In-Reply-To: <48DA13EF.3060103@shopzeus.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <48DA13EF.3060103@shopzeus.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/216 X-Sequence-Number: 31529 > Should I use gjournal on FreeBSD 7? Or just soft updates? > > Here is my opinion: I suspect that gjournal would be much slower than > soft updates. Also gjournal is relatively new code, not very well > tested. But gjournal is better when the system crashes. Although I have > heard that sometimes gjournal will crash the system itself. There are > more pros for soft updates I would pefer that. But please let me > know if I'm wrong. If softupdates suites your needs why not just use that? :-) Is performance adequate with softupdates? I have a 103 GB db on FreeBSD 7.0 and softupdates and it has survived one unplanned stop when we had a power-outage lasting some hours. -- regards Claus When lenity and cruelty play for a kingdom, the gentler gamester is the soonest winner. Shakespeare