From owner-freebsd-database@FreeBSD.ORG  Tue Jul 22 09:02:30 2003
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
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 8A41637B407; Tue, 22 Jul 2003 09:02:30 -0700 (PDT)
Received: from mail.nsnpt.navy.mil (mail.nsnpt.navy.mil [205.70.65.3])
	by mx1.FreeBSD.org (Postfix) with ESMTP
	id 668C043FB1; Tue, 22 Jul 2003 09:02:26 -0700 (PDT)
	(envelope-from HelpDesk@nsnpt.navy.mil)
Received: by MAIL with Internet Mail Service (5.5.2653.19)
	id <PAFDNFJA>; Tue, 22 Jul 2003 12:02:24 -0400
Message-ID: <549CB3C0EA63D711B58F00508B139A512B4BB0@MAIL>
From: "Help Desk IT (NSNPT N6N)" <HelpDesk@nsnpt.navy.mil>
To: 'Bosko Milekic' <bmilekic@technokratis.com>,
	Dan Langille <dan@langille.org>
Date: Tue, 22 Jul 2003 12:02:17 -0400
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain;
	charset="iso-8859-1"
cc: freebsd-database@freebsd.org
cc: freebsd-performance@freebsd.org
cc: Jason Stone <freebsd-performance@dfmm.org>
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
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>,
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>,
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 22 Jul 2003 16:02:32 -0000

  I had asked yesterday to stop receiving these messages because I followed
the directions about removing our address from your list and your system
tells me we're not part of it.  Pleasew remove us as soon as possible.

R/
John

-----Original Message-----
From: Bosko Milekic [mailto:bmilekic@technokratis.com]
Sent: Tuesday, July 22, 2003 8:03 AM
To: Dan Langille
Cc: freebsd-database@freebsd.org; freebsd-performance@freebsd.org; Jason
Stone
Subject: Re: Tuning for PostGreSQL Database



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/
_______________________________________________
freebsd-database@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "freebsd-database-unsubscribe@freebsd.org"