Re: Tuning for PostGreSQL Database

From: Alexander Leidinger (Alexander_at_Leidinger.net)
Date: 07/22/03

  • Next message: Alexander Leidinger: "Re: Tuning for PostGreSQL Database"
    Date: Tue, 22 Jul 2003 12:12:11 +0200
    To: freebsd-performance@freebsd.org
    
    

    On Mon, 21 Jul 2003 13:16:45 -0700
    Sean Chittenden <sean@chittenden.org> wrote:

    > Well, think about it. What happens when you pull the plug while the
    > OS is sitting on a pile of data that it's waiting to flush to disk?
    > The problem isn't so much with the WAL logs, so much as it is with the
    > actual files that contain the databases/table's data. Any kind of
    > volatle backed buffer increases the danger of data loss.
    >
    > Good solution for these concerns? Get a UPS.

    Thats not only a good solution, it's the only solution for mainstream PC
    hardware...

    Bye,
    Alexander.

    -- 
                    Where do you think you're going today?
    http://www.Leidinger.net                       Alexander @ Leidinger.net
      GPG fingerprint = C518 BC70 E67F 143F BE91  3365 79E2 9C60 B006 3FE7
    _______________________________________________
    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: Alexander Leidinger: "Re: Tuning for PostGreSQL Database"

    Relevant Pages

    • RAID1 not save my system in case disk failure
      ... After dropping I/O operations on disk chained to ... Waiting Queue entries: ... Disconnected Queue entries: ... Please file a bug report against this driver. ...
      (Linux-Kernel)
    • Re: Hey Back People-something new!!!
      ... Hopefully *after* I will be able to flush them... ... It's micro surgery which leaves a scar about a 1.5" long. ... They basically go in the side and remove the bad disk a little bit at a ... worth of info on it which is not enough going under a knife, ...
      (alt.support.chronic-pain)
    • Re: How can /proc/loadavg be used ?
      ... So a process waiting for a disk or network input is NOT ... which jobs are ready to run, ...
      (comp.unix.shell)
    • Re: SATA exceptions with 2.6.20-rc5
      ... On 1/15/07, Jeff Garzik wrote: ... According to the drive guys, FLUSH CACHE ... flush on this device would, I believe, involve damage to the disk that ... I assume that large enough customers can buy enterprise-type command ...
      (Linux-Kernel)
    • Re: Do not overload dispatch queue (Was: Re: IO scheduler based IO controller V10)
      ... We shall have to experiment what is a good waiting perioed. ... it's losing out to "stock" but looks pretty competetive otherwise. ... Disk is sounding too seeky, ... be doing the async IO which will make the disk very quiet (since it's ...
      (Linux-Kernel)