Here is the SCSI output:

Web Server

SCSI subsystem driver Revision: 1.00
megaraid: v1.18j (Release Date: Mon Jul  7 14:39:55 EDT 2003)
megaraid: found 0x1028:0x000f:idx 0:bus 4:slot 3:func 0
scsi0 : Found a MegaRAID controller at 0xf883f000, IRQ: 18
scsi0 : Enabling 64 bit support
megaraid: [412W:H406] detected 1 logical drives
megaraid: supports extended CDBs.
megaraid: channel[1] is raid.
megaraid: channel[2] is raid.
scsi0 : LSI Logic MegaRAID 412W 254 commands 15 targs 5 chans 7 luns


Database Server

SCSI subsystem driver Revision: 1.00
megaraid: v1.18j (Release Date: Mon Jul  7 14:39:55 EDT 2003)
megaraid: found 0x101e:0x1960:idx 0:bus 5:slot 0:func 0
scsi0 : Found a MegaRAID controller at 0xf883f000, IRQ: 21
scsi0 : Enabling 64 bit support
megaraid: [196T:3.33] detected 1 logical drives
megaraid: supports extended CDBs.
megaraid: channel[1] is raid.
megaraid: channel[2] is raid.
scsi0 : LSI Logic MegaRAID 196T 254 commands 15 targs 5 chans 7 luns
Starting timer : 0 0
blk: queue c5f2d218, I/O limit 4095Mb (mask 0xffffffff)
scsi0: scanning virtual channel 0 for logical drives.
  Vendor: MegaRAID  Model: LD 0 RAID5   86G  Rev: 196T
  Type:   Direct-Access                      ANSI SCSI revision: 02
Starting timer : 0 0


The webserver is a 1U and it actually performs better on the IO than the database server even though the database server is running 6 disks versus 3.

The database server is a PE (Power Edge) 6600

Database Server IO:

[EMAIL PROTECTED] root]# /sbin/hdparm -tT /dev/sda

/dev/sda:
 Timing buffer-cache reads:   1888 MB in  2.00 seconds = 944.00 MB/sec
 Timing buffered disk reads:   32 MB in  3.06 seconds =  10.46 MB/sec

Second Database Server IO:

[EMAIL PROTECTED] root]# /sbin/hdparm -tT /dev/sda

/dev/sda:
 Timing buffer-cache reads:   1816 MB in  2.00 seconds = 908.00 MB/sec
 Timing buffered disk reads:   26 MB in  3.11 seconds =   8.36 MB/sec
[EMAIL PROTECTED] root]#

Which is just horrible.


Sincerely,

Joshua D. Drake






Patrick Welche wrote:
On Thu, Jul 21, 2005 at 09:19:04PM -0700, Luke Lonergan wrote:

Joshua,

On 7/21/05 7:53 PM, "Joshua D. Drake" <[EMAIL PROTECTED]> wrote:

Well I know that isn't true at least not with ANY of the Dells my
customers have purchased in the last 18 months. They are still really,
really slow.

That's too bad, can you cite some model numbers?  SCSI?


I would be interested too, given

   http://www.netbsd.org/cgi-bin/query-pr-single.pl?number=30531


Cheers,

Patrick

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org


--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to