Re: Tuning for PostGreSQL Database

From: Bosko Milekic (bmilekic_at_technokratis.com)
Date: 07/22/03

  • Next message: Tom Samplonius: "Re: Tuning for PostGreSQL Database" 
    Date: Tue, 22 Jul 2003 12:03:07 +0000
To: Dan Langille <dan@langille.org>

    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/
_______________________________________________
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: Tom Samplonius: "Re: Tuning for PostGreSQL Database"

    Relevant Pages

    • Re: Tuning for PostGreSQL Database
      ... If softupdates changes ... >> postgresql server because postgresql counts on fsync in order to make its ... > If this means all FreeBSD-PostgreSQL users need to change their ... Check the mailing lists, ...
      (freebsd-performance)
    • Re: Tuning for PostGreSQL Database
      ... If softupdates changes ... >> postgresql server because postgresql counts on fsync in order to make its ... If softupdates breaks the semantics of sync/fsync it affects a lot more ... does this - reorders/delays sync/fsync - on writes within a file? ...
      (freebsd-performance)
    • Re: Tuning for PostGreSQL Database
      ... relies on fsync semantics before confirming the acceptance of email. ... I would guess that PostGreSQL uses fsyncand softupdates do not ...
      (freebsd-performance)
    • Re: terrible performance in 6.1beta4
      ... "you may have to dedicate more memory to it" ... I don't know PostgreSQL much but I also has been recently running quite ... After comparing my config file to yours I see some differences: ... I suspect that the main difference in our configs is fsync setting ...
      (freebsd-questions)
    • Re: Tuning for PostGreSQL Database
      ... > the semantics of sync/fsync, then it absolutely has to be off for a ... > postgresql server because postgresql counts on fsync in order to make its ... If this means all FreeBSD-PostgreSQL users need to change their ...
      (freebsd-performance)