From owner-freebsd-database@FreeBSD.ORG Wed Aug 27 18:22:33 2003 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id C64F716A4BF; Wed, 27 Aug 2003 18:22:33 -0700 (PDT) Received: from mta6.adelphia.net (mta6.adelphia.net [68.168.78.190]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2D27F43F75; Wed, 27 Aug 2003 18:22:32 -0700 (PDT) (envelope-from wmoran@potentialtech.com) Received: from potentialtech.com ([24.53.179.151]) by mta6.adelphia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20030828012232.SPEO18217.mta6.adelphia.net@potentialtech.com>; Wed, 27 Aug 2003 21:22:32 -0400 Message-ID: <3F4D5957.8000204@potentialtech.com> Date: Wed, 27 Aug 2003 21:22:31 -0400 From: Bill Moran User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.3) Gecko/20030429 X-Accept-Language: en-us, en MIME-Version: 1.0 To: freebsd-performance@freebsd.org, freebsd-database@freebsd.org, freebsd-fs@freebsd.org Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Subject: Some additional tests run on my performance testing X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 28 Aug 2003 01:22:33 -0000 First off, I want to thank everyone who responded with suggestions and comments. I was worried that I might get a lot of flames about these test, and that's not what happened. The most common suggestion I received was "use FreeBSD 4.8", so I managed to make some time between the electrical storms today, and my regular work to do just that. Unfortunately (as you'll see) the results were _worse_ than with FreeBSD 5.1. I'm interested in two major things right now: 1 - can anyone suggest anything I might be doing wrong to get such lousy results? 2 - Can someone please try the tests on SCSI hardware? I don't have any SCSI systems available to test on, and I'd like to figure out if it's the filesystem or the ATA driver that's the problem. Hell, can someone try out the tests on some other brand of ATA/HDD, to make sure FreeBSD doesn't just have some grief with this particular piece of hardware? The updated test results are the same place the previous tests were: http://www.potentialtech.com/wmoran/postgresql.php I'm attaching dmesg from the test machine to this email, if anyone knows of any problems with this hardware and FreeBSD, please let me know so I can stop banging my head against this and just accept that it's a hardware problem ;) I was assuming that the "falling back to PIO mode" was because this board didn't support DMA, but I'm beginning to wonder ... -- Bill Moran Potential Technologies http://www.potentialtech.com Copyright (c) 1992-2003 The FreeBSD Project. Copyright (c) 1979, 1980, 1983, 1986, 1988, 1989, 1991, 1992, 1993, 1994 The Regents of the University of California. All rights reserved. FreeBSD 4.8-RELEASE #0: Thu Apr 3 10:53:38 GMT 2003 root@freebsd-stable.sentex.ca:/usr/obj/usr/src/sys/GENERIC Timecounter "i8254" frequency 1193182 Hz CPU: AMD-K6(tm) 3D processor (450.13-MHz 586-class CPU) Origin = "AuthenticAMD" Id = 0x58c Stepping = 12 Features=0x8021bf AMD Features=0x80000800 real memory = 58720256 (57344K bytes) avail memory = 51949568 (50732K bytes) Preloaded elf kernel "kernel" at 0xc051d000. K6-family MTRR support enabled (2 registers) md0: Malloc disk Using $PIR table, 7 entries at 0xc00fa040 npx0: on motherboard npx0: INT 16 interface pcib0: on motherboard pci0: on pcib0 agp0: mem 0x50000000-0x5fffffff at device 0.0 on pci0 atapci0: port 0x2040-0x204f,0-0x3,0-0x7,0-0x3,0-0x7 irq 0 at device 0.1 on pci0 ata0: at 0x1f0 irq 14 on atapci0 ata1: at 0x170 irq 15 on atapci0 isab0: at device 1.0 on pci0 isa0: on isab0 pci0: (vendor=0x1039, dev=0x0009) at 1.1 ohci0: irq 11 at device 1.2 on pci0 ohci0: Could not map memory device_probe_and_attach: ohci0 attach returned 6 pcib2: at device 2.0 on pci0 pci1: on pcib2 pci1: at 0.0 rl0: port 0x2400-0x24ff mem 0x41000000-0x410000ff irq 10 at device 5.0 on pci0 rl0: Ethernet address: 00:c0:ca:14:03:eb miibus0: on rl0 rlphy0: on miibus0 rlphy0: 10baseT, 10baseT-FDX, 100baseTX, 100baseTX-FDX, auto pci0: (vendor=0x125d, dev=0x1969) at 10.0 irq 5 pcib1: on motherboard pci2: on pcib1 orm0: