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

Поиск
Список
Период
Сортировка
От Don Baccus
Тема Re: system usage stats (Was: Re: Why Not MySQL? )
Дата
Msg-id 3.0.1.32.20000504101153.010d65d0@mail.pacifier.com
обсуждение исходный текст
Ответ на Re: system usage stats (Was: Re: Why Not MySQL? )  ("Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>)
Список 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 по дате отправления:

Предыдущее
От: "Oliver Elphick"
Дата:
Сообщение: Is this a bug in the table definition or in PostgreSQL?
Следующее
От: Don Baccus
Дата:
Сообщение: Re: --enable-locale and SET command ...