From owner-freebsd-performance@FreeBSD.ORG  Tue Jul 22 03:12:25 2003
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
Delivered-To: freebsd-performance@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 805C037B401
	for <freebsd-performance@freebsd.org>;
	Tue, 22 Jul 2003 03:12:25 -0700 (PDT)
Received: from mailout10.sul.t-online.com (mailout10.sul.t-online.com
	[194.25.134.21])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 7204D43FA3
	for <freebsd-performance@freebsd.org>;
	Tue, 22 Jul 2003 03:12:24 -0700 (PDT)
	(envelope-from Alexander@Leidinger.net)
Received: from fwd00.aul.t-online.de 
	by mailout10.sul.t-online.com with smtp 
	id 19eu87-0004m2-06; Tue, 22 Jul 2003 12:12:23 +0200
Received: from Andro-Beta.Leidinger.net
	(rCLbumZ1gevg1eIzFEXQ7CTmV4DRBor-h6PqCp51l5NTzkDdT88MQp@[217.229.208.90]) by
	fmrl00.sul.t-online.com
	with esmtp id 19eu7x-1BvxHk0; Tue, 22 Jul 2003 12:12:13 +0200
Received: from Magelan.Leidinger.net (Magelan [192.168.1.1])
	h6MACB9P023963	for <freebsd-performance@freebsd.org>;
	Tue, 22 Jul 2003 12:12:11 +0200 (CEST)
	(envelope-from Alexander@Leidinger.net)
Received: from Magelan.Leidinger.net (netchild@localhost [127.0.0.1])
	by Magelan.Leidinger.net (8.12.9/8.12.9) with SMTP id h6MACBo7000902
	for <freebsd-performance@freebsd.org>;
	Tue, 22 Jul 2003 12:12:11 +0200 (CEST)
	(envelope-from Alexander@Leidinger.net)
Date: Tue, 22 Jul 2003 12:12:11 +0200
From: Alexander Leidinger <Alexander@Leidinger.net>
To: freebsd-performance@freebsd.org
Message-Id: <20030722121211.27684f49.Alexander@Leidinger.net>
In-Reply-To: <20030721201645.GD61464@perrin.int.nxad.com>
References: <Pine.BSF.4.05.10307191344080.16986-100000@misery.sdf.com>
	<20030721043501.F14379-100000@walter>
	<20030721192645.GB61464@perrin.int.nxad.com>
	<20030721194519.GE55392@nasby.net>
	<20030721201645.GD61464@perrin.int.nxad.com>
X-Mailer: Sylpheed version 0.9.3claws (GTK+ 1.2.10; i386-portbld-freebsd5.1)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Seen: false
X-ID: rCLbumZ1gevg1eIzFEXQ7CTmV4DRBor-h6PqCp51l5NTzkDdT88MQp@t-dialin.net
Subject: Re: Tuning for PostGreSQL Database
X-BeenThere: freebsd-performance@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Performance/tuning <freebsd-performance.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-Post: <mailto:freebsd-performance@freebsd.org>
List-Help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 22 Jul 2003 10:12:25 -0000

On Mon, 21 Jul 2003 13:16:45 -0700
Sean Chittenden <sean@chittenden.org> wrote:

> Well, think about it.  What happens when you pull the plug while the
> OS is sitting on a pile of data that it's waiting to flush to disk?
> The problem isn't so much with the WAL logs, so much as it is with the
> actual files that contain the databases/table's data.  Any kind of
> volatle backed buffer increases the danger of data loss.
> 
> Good solution for these concerns?  Get a UPS.

Thats not only a good solution, it's the only solution for mainstream PC
hardware...

Bye,
Alexander.

-- 
                Where do you think you're going today?

http://www.Leidinger.net                       Alexander @ Leidinger.net
  GPG fingerprint = C518 BC70 E67F 143F BE91  3365 79E2 9C60 B006 3FE7