Re: Tuning for PostGreSQL Database

From: Mikko Työläjärvi (mbsd_at_pacbell.net)
Date: 07/22/03

  • Next message: Michael Conlen: "sbwait state for loaded Apache server" 
    Date: Tue, 22 Jul 2003 09:31:51 -0700 (PDT)
To: Dan Langille <dan@langille.org>

    On Tue, 22 Jul 2003, 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?

    I think you can relax. Check the mailing lists, or google a bit and
    you'll find similar discussions. For example:

    <http://www.ornl.gov/cts/archives/mailing-lists/qmail/2000/02/msg00703.html>

    In short: fsync() works with soft-updates. Too many things would
    break otherwise.

      $.02,
      /Mikko
    _______________________________________________
    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: Michael Conlen: "sbwait state for loaded Apache server"

    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 ...
      (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: Witch database do you recommend?
      ... then you should probably use PostgreSQL as it's SQL functionality fully ... those on google) and there is no general answer to your question. ... |>> to be great, the mailing lists great, and just getting it working ... To unsubscribe, ...
      (freebsd-questions)
    • Re: [OT] PostgreSQL: bytea help needed.
      ... >> mailing lists gated to the pgsql hierarchy, ... >> The NAN moderators are dragging their feet about getting a PostgreSQL ... >> there may be a PostgreSQL user, like in the linux group. ...
      (comp.os.linux.misc)
    • Re: PostgreSQL
      ... > There is a decent tool called PGAdmin III that would solve most of your ... Secondly you can always join the PostgreSQL list and seek help ... > PG has a decent ODBC driver as well, ... >> and I couldn't find any good web pages or mailing lists to get me over ...
      (Fedora)