Re: Tuning for PostGreSQL Database

From: Dan Langille (dan_at_langille.org)
Date: 07/22/03

  • Next message: Bosko Milekic: "Re: Tuning for PostGreSQL Database" 
    To: Jason Stone <freebsd-performance@dfmm.org>
Date: Tue, 22 Jul 2003 11:37:44 -0400

    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/
_______________________________________________
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: Bosko Milekic: "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 this means all FreeBSD-PostgreSQL users need to change their ...
      (freebsd-performance)
    • [Full-Disclosure] MDKSA-2005:040 - Updated PostgreSQL packages fix multiple vulnerabilities
      ... A number of vulnerabilities were found and corrected in the PostgreSQL ... the EXECUTE permission check for functions using the CREATE AGGREGATE ... privileges of the user running the postgresql server (CAN-2005-0245 ... the GPG public key of the Mandrakelinux Security Team by executing: ...
      (Full-Disclosure)
    • MDKSA-2005:040 - Updated PostgreSQL packages fix multiple vulnerabilities
      ... A number of vulnerabilities were found and corrected in the PostgreSQL ... the EXECUTE permission check for functions using the CREATE AGGREGATE ... privileges of the user running the postgresql server (CAN-2005-0245 ... the GPG public key of the Mandrakelinux Security Team by executing: ...
      (Bugtraq)
    • Re: Restarting rc.conf
      ... >> I set up a postgresql server under FreeBDSD 5.3 stable. ... how can I make FreeBSD execute the modified rc.conf? ... >> can I make the system be aware of that WITHOUT REBOOTING, in other words, ... If this is the first time you're installing a PostgreSQL database, ...
      (freebsd-questions)