Re: Tuning for PostGreSQL Database

From: Jim C. Nasby (jim_at_nasby.net)
Date: 07/21/03

  • Next message: Jim C. Nasby: "Re: Tuning for PostGreSQL Database" 
    Date: Mon, 21 Jul 2003 14:26:43 -0500
To: Jason Stone <freebsd-performance@dfmm.org>

    On Mon, Jul 21, 2003 at 05:06:47AM -0700, Jason Stone wrote:
    > -----BEGIN PGP SIGNED MESSAGE-----
    > Hash: SHA1
    >
    >
    > On Sat, 19 Jul 2003, Tom Samplonius 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)?
     
    No, afaik it only fsync's the write-ahead-logs. 

    -- 
Jim C. Nasby, Database Consultant                  jim@nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
_______________________________________________
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: Jim C. Nasby: "Re: Tuning for PostGreSQL Database"

    Relevant Pages