Date: Tue, 22 Jul 2003 07:31:23 -0700 (PDT) From: Tom Samplonius <tom@sdf.com> To: Sean Chittenden <sean@chittenden.org> Cc: Jason Stone <freebsd-performance@dfmm.org> Subject: Re: Tuning for PostGreSQL Database Message-ID: <Pine.BSF.4.05.10307220730360.16986-100000@misery.sdf.com> In-Reply-To: <20030721192645.GB61464@perrin.int.nxad.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Mon, 21 Jul 2003, Sean Chittenden wrote: > > > Softupdates on, async off. Softupdates is just a better async. > > > > postgresql fsync's all its files before returning from a commit in > > order to ensure durability, right? Does softupdates interfere with > > the functioning of sync(2)/fsync(2)? > > It can, yes, but that's the risk of soft updates. From tuning(7): No it can't. Regardless of how softupdates re-orders filesystem activity, fsync flushes all dirty buffers. Tom
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.4.05.10307220730360.16986-100000>