Re: Some additional tests run on my performance testing

From: David Schultz (das_at_FreeBSD.ORG)
Date: 08/28/03

  • Next message: Sean Chittenden: "Re: Some additional tests run on my performance testing" 
    Date: Thu, 28 Aug 2003 01:59:47 -0700
To: Robert Watson <rwatson@FreeBSD.ORG>

    On Wed, Aug 27, 2003, Robert Watson wrote:
    > On Wed, 27 Aug 2003, Bill Moran wrote:
    >
    > > Unfortunately (as you'll see) the results were _worse_ than with FreeBSD
    > > 5.1.
    > ..
    > > ad0s1a: UDMA ICRC error writing fsbn 1458368 of 729184-729215 (ad0s1 bn 1458368; cn 241 tn 12 sn 44) retrying
    > > ad0s1a: UDMA ICRC error writing fsbn 1458368 of 729184-729215 (ad0s1 bn 1458368; cn 241 tn 12 sn 44) retrying
    > > ad0s1a: UDMA ICRC error writing fsbn 1458368 of 729184-729215 (ad0s1 bn 1458368; cn 241 tn 12 sn 44) retrying
    > > ad0s1a: UDMA ICRC error writing fsbn 1458368 of 729184-729215 (ad0s1 bn 1458368; cn 241 tn 12 sn 44) falling back to PIO mode

    If your drives are using PIO in FreeBSD and DMA under other
    operating systems, that would certainly explain the problem. Are
    the drives also in PIO mode under Linux? Does this message pop up
    with 4.8, 5.1, or both? I understand that the usual cause is bad
    cabling.

    > Did you look at any of the blocksize-related patches that have been
    > floating around?

    I tried his tests on a stock pgsql 7.3.4, twice with an 8K block
    filesystem and twice with a 16K block UFS2 filesystem and measured
    an improvement of about 4% for the 8K filesystem. (Take this cum
    grano salis though, since this was an informal test and I don't
    have enough data to draw a statistically significant conclusion.)
    It turns out that the tables in Bill's tests have no indices, so
    pgsql winds up doing practically nothing but sequential reads and
    sequential writes of entire tables. A more typical database load
    would probably be characterized by mostly random access patterns
    and possibly more synchronous writes to the WAL log.
    _______________________________________________
    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: Sean Chittenden: "Re: Some additional tests run on my performance testing"

    Relevant Pages

    • Re: linux hard drive failed, clicking on bootup
      ... E) hard drives do and will fail; this can mostly only be predicted ... one's hardware, if the hardware is broken/defective (though it can ... * try a full read test of the filesystem, partition, volume, or full ... fsck/e2fsck - but with the -n option, so no writing is done to the ...
      (comp.os.linux.setup)
    • Re: Looking for a Text on ZFS
      ... Even a 64bit filesystem still has gigantic reserves of space and ... well the drives can still live on their own if they are ever seperated. ... Since I use HDs on my computers, I have had about 20 to 25 ...
      (freebsd-questions)
    • [semi-OT] Data archiving (was Re: Query on adding a USB hdd)
      ... encrypt filesystem for archives. ... Tape (using tar, and a media used by "large data processing shops", ... whiz specialized crap that NASA seems to love) or SCSI hard drives ... How would you get the source off if the filesystem is not ...
      (Debian-User)
    • Re: All filesystems hang under long periods of heavy load (read and write) on a filesystem
      ... This is a Compaq DL380 with SCSI RAID and two IDE drives. ... the filesystem on the partition being written to. ... Dec 22 14:48:08 www2 kernel: ...
      (Linux-Kernel)
    • Re: Corrupted ext3 filesystem on top of Adaptec RAID5 array
      ... SATA-II drives are too much for the box... ... if it's hardware raid, use the bios to see the RAID logs for any ... The filesystem remounted read only due to some error I can't discern ... filesystem and partition for '/' and increase the swap partition. ...
      (Ubuntu)