Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 4E3569FBB14 for ; Tue, 8 May 2007 05:22:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 33787-02 for ; Tue, 8 May 2007 05:22:01 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.235]) by postgresql.org (Postfix) with ESMTP id D44239FBBB7 for ; Tue, 8 May 2007 05:22:09 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 70so1777865wra for ; Tue, 08 May 2007 01:22:08 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=Y7JYB0RkYGZ55X/mIwx15Kei6DH+x1W9HMEhh2o6bHGYyeedE2/+/trV4hXUZ/yhY3LaKqMvvvyaaONM5KE3kz3C8ukeXN+vktNEvHGBNXaQcxB+teG+lMkQMR7MvEoCnHvCd9dHUTxVYhLGvqG799muwIRI2nq6I1RlDomICa0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=i/8HTKZEMizvNFYSSJA6FazXnGB1V9RQsn3PSex9CyOwZRNKcXlQpIOJDzG+hP3ncTFCsy2So6bjM3Ey4hhKsoemxcdUtl7JtBvV0TWMxiDj2EY38exefKgdkF/1ZTFLjnUguHjrLGRdOQF2oxUu0C5lpVGH/o2qh0uNcAxMqvI= Received: by 10.78.166.7 with SMTP id o7mr2347445hue.1178612528210; Tue, 08 May 2007 01:22:08 -0700 (PDT) Received: from ?192.168.1.34? ( [82.14.82.23]) by mx.google.com with ESMTP id h1sm243491ugf.2007.05.08.01.22.01; Tue, 08 May 2007 01:22:06 -0700 (PDT) Message-ID: <46403313.9070604@enterprisedb.com> Date: Tue, 08 May 2007 09:21:39 +0100 From: Heikki Linnakangas User-Agent: Icedove 1.5.0.10 (X11/20070329) MIME-Version: 1.0 To: david@lang.hm CC: =?UTF-8?B?5p2O5b2mIElhbiBMaQ==?= , PostgreSQL Performance Subject: Re: Best OS for Postgres 8.2 References: <1178574927.533849.90730@e51g2000hsg.googlegroups.com> <463FFF76.5070108@gmail.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/87 X-Sequence-Number: 24477 david@lang.hm wrote: > if you don't journal your data then you avoid the problems above, but in > a crash you may find that you lost data, even though the filesystem is > 'intact' according to fsck. PostgreSQL itself journals it's data to the WAL, so that shouldn't happen. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com