Re: system usage stats (Was: Re: Why Not MySQL? )

From: Don Baccus <dhogaza(at)pacifier(dot)com>
To: "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: system usage stats (Was: Re: Why Not MySQL? )
Date: 2000-05-04 17:11:53
Message-ID: 3.0.1.32.20000504101153.010d65d0@mail.pacifier.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-05-04 17:35:16 Re: 7.0RC2 compile error !
Previous Message Don Baccus 2000-05-04 17:05:19 Re: --enable-locale and SET command ...