Re: Tuning for PostGreSQL Database

From: Tom Samplonius (tom_at_sdf.com)
Date: 07/22/03

  • Next message: Mikko Työläjärvi: "Re: Tuning for PostGreSQL Database" 
    Date: Tue, 22 Jul 2003 07:31:23 -0700 (PDT)
To: Sean Chittenden <sean@chittenden.org>

    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

    _______________________________________________
    freebsd-performance@freebsd.org mailing list
    http://lists.freebsd.org/mailman/listinfo/freebsd-performance
    To unsubscribe, send any mail to "freebsd-performance-unsubscribe@freebsd.org"

  • Next message: Mikko Työläjärvi: "Re: Tuning for PostGreSQL Database"