Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 22 Jul 2003 12:03:07 +0000
From:      Bosko Milekic <bmilekic@technokratis.com>
To:        Dan Langille <dan@langille.org>
Cc:        Jason Stone <freebsd-performance@dfmm.org>
Subject:   Re: Tuning for PostGreSQL Database
Message-ID:  <20030722120307.GA59423@technokratis.com>
In-Reply-To: <3F1D2208.2124.52B03E6A@localhost>
References:  <20030721192645.GB61464@perrin.int.nxad.com> <3F1D2208.2124.52B03E6A@localhost>

next in thread | previous in thread | raw e-mail | index | archive | help

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/



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030722120307.GA59423>