Re: system usage stats (Was: Re: Why Not MySQL? ) - Mailing list pgsql-hackers

From Don Baccus
Subject Re: system usage stats (Was: Re: Why Not MySQL? )
Date
Msg-id 3.0.1.32.20000504101153.010d65d0@mail.pacifier.com
Whole thread Raw
In response to Re: system usage stats (Was: Re: Why Not MySQL? )  ("Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>)
List pgsql-hackers
At 11:03 AM 5/4/00 -0500, Ross J. Reedstrom wrote:

>So, 6.5.3 is running on Ultra 160 drives, with the controller throttled to
>80 MB/s, and 7.0 is running on Ultra 2 drives, which also has a controller
>maximum of 80 MB/s.  However, the sustained transfer speed of the drives
>themselves are what should be limiting: if they're all relatively modern
>drives, 20MB/s is typical, so neither config will max out the controller.
>(2 drives each, right?)

Not to mention that seek times make it very difficult to max out 
a controller even if theoretically possible with four drives, unless
you're striping and doing large transfers or lookaheads, etc.

If one's got 10K drives and the other 7.2K drives, you'll certainly
see a difference in transfer rate and seek time.

So ... what are the disk configurations?



- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.
 


pgsql-hackers by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Is this a bug in the table definition or in PostgreSQL?
Next
From: Don Baccus
Date:
Subject: Re: --enable-locale and SET command ...