Tuning for PostGreSQL Database
tom at sdf.com
Tue Jul 22 09:23:29 PDT 2003
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.
More information about the freebsd-performance