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)
    • Device mapper/LVM throughput problem
      ... I've just tested the disk throughput on my machine using hdparm and found some ... When I test the throughput on a raid partition or the LVM ... HDIO_DRIVE_CMD(wait for flush complete) failed: Inappropriate ioctl for ...
      (Linux-Kernel)