From owner-freebsd-database@FreeBSD.ORG Tue Jul 22 08:59:03 2003 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4165237B401; Tue, 22 Jul 2003 08:59:03 -0700 (PDT) Received: from godel.mtl.distributel.net (nat.MTL.distributel.NET [66.38.181.24]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8B17C43F75; Tue, 22 Jul 2003 08:59:02 -0700 (PDT) (envelope-from bmilekic@technokratis.com) Received: from godel.mtl.distributel.net (localhost [127.0.0.1]) h6MC37EH059476; Tue, 22 Jul 2003 12:03:07 GMT (envelope-from bmilekic@technokratis.com) Received: (from bmilekic@localhost) by godel.mtl.distributel.net (8.12.9/8.12.9/Submit) id h6MC37lw059475; Tue, 22 Jul 2003 12:03:07 GMT X-Authentication-Warning: godel.mtl.distributel.net: bmilekic set sender to bmilekic@technokratis.com using -f Date: Tue, 22 Jul 2003 12:03:07 +0000 From: Bosko Milekic To: Dan Langille Message-ID: <20030722120307.GA59423@technokratis.com> References: <20030721192645.GB61464@perrin.int.nxad.com> <3F1D2208.2124.52B03E6A@localhost> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3F1D2208.2124.52B03E6A@localhost> User-Agent: Mutt/1.4.1i cc: freebsd-database@freebsd.org cc: freebsd-performance@freebsd.org cc: Jason Stone Subject: Re: Tuning for PostGreSQL Database X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 22 Jul 2003 15:59:03 -0000 On Tue, Jul 22, 2003 at 11:37:44AM -0400, Dan Langille wrote: > On 21 Jul 2003 at 20:35, Jason Stone wrote: > > > I feel like this is an extremely important point. If softupdates changes > > the semantics of sync(2)/fsync(2), then it absolutely has to be off for a > > postgresql server because postgresql counts on fsync in order to make its > > durability guarantees. > > If this means all FreeBSD-PostgreSQL users need to change their > setup, we need to do something ASAP. I'd first recommend getting the > confirmation from the PostgreSQL team, then adjusting the PostgreSQL > documenation and the FreeBSD port. > > Does anyone feel this is urgent enough that they'll do something > about it? > -- > Dan Langille : http://www.langille.org/ You sound like you know exactly what's involved. :-) -- Bosko Milekic * bmilekic@technokratis.com * bmilekic@FreeBSD.org TECHNOkRATIS Consulting Services * http://www.technokratis.com/