SCSI与IDE性能测试 [英] SCSI vs. IDE performance test
问题描述
http://hardware.devchannel.org/hardw...&tid=38&tid=49
-
------------------------------------------------ -----------------
Ron Johnson，Jr。 ro *********** @ cox.net
美国路易斯安那州杰斐逊
我不能让你堕胎，但你可以*让我支付
儿童抚养费18年？但是，如果我想要孩子（以及
所需的所有费用）* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *这9个月，运气不好???
---------------------------（播出结束） ---------------------------
提示1：订阅和取消订阅命令转到 ma ******* @ postgresql.org
http://hardware.devchannel.org/hardw...&tid=38&tid=49
--
-----------------------------------------------------------------
Ron Johnson, Jr. ro***********@cox.net
Jefferson, LA USA
I can''t make you have an abortion, but you can *make* me pay
child support for 18 years? However, if I want the child (and
all the expenses that entails) for the *rest*of*my*life*, and you
don''t want it for 9 months, tough luck???
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org
推荐答案
对IDE的SCSI改进似乎在测试中被高估了。我希望
预计最多可以提高30％。其他评论似乎指出IDE
表现同样好或更好。
见汤姆的硬件：
http://www20.tomshardware.com/storag...305/index.html
Stephen
" Ron Johnson" <为RO *********** @ cox.net>在消息中写道
news：1066837102.12532.176.camel@haggis ...
The SCSI improvement over IDE seems overrated in the test. I would have
expected at most a 30% improvement. Other reviews seem to point out that IDE
performs just as well or better.
See Tom''s hardware:
http://www20.tomshardware.com/storag...305/index.html
Stephen
"Ron Johnson" <ro***********@cox.net> wrote in message
news:1066837102.12532.176.camel@haggis...
http://hardware.devchannel.org/hardw...9.shtml?tid=20
& tid = 38& tid = 49
-
------------------------- ----------------------------------------
Ron Johnson，Jr。< a href =mailto：ro *********** @ cox.net> ro *********** @ cox.net
杰斐逊，洛杉矶美国
我不能让你堕胎，但你可以*让我支付孩子支持18年？但是，如果我想要孩子（以及所需的所有费用）* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ??
---------------------------（广播结束）-------- -------------------
提示1：订阅和取消订阅命令转到 ma ******* @ postgresql.org
在星期三，2003-10-22 11:01 ，Stephen写道：
On Wed, 2003-10-22 at 11:01, Stephen wrote:
对IDE的SCSI改进似乎在测试中被高估了。我希望最多可以提高30％。其他评论似乎指出IDE
的表现同样好或更好。
看看汤姆的硬件：
http://www20.tomshardware.com/storag...305/index.html
当TCQ在IDE驱动器中成为现实时，他们将有一个战斗机会，但是较慢的寻道时间和旋转速度仍将是b
。
另外，一个8MB的缓存*确实*会产生很大的不同吗？
毕竟，它只能缓存120GB驱动器的0.0067％和新的300GB磁盘的0.00267％
。
说到这个，300GB的硬盘听起来像是一个梦想的近乎
行存储，甚至是夜间备份，如果它被放入
SBB型包装。
http://www20.tomshardware.com/storag...008/in dex.html
设想一个方案，你快速pg_dump到300GB驱动器，
然后，在闲暇时，将转储文件tar到磁带。将一些条带绑在一起，
并保持一个月的备份在线以便快速恢复，以及磁带存档
，以防条带集浪费。
" Ron Johnson" <为RO *********** @ cox.net>在消息中写道
新闻：1066837102.12532.176.camel@haggis ...
The SCSI improvement over IDE seems overrated in the test. I would have
expected at most a 30% improvement. Other reviews seem to point out that IDE
performs just as well or better.
See Tom''s hardware:
http://www20.tomshardware.com/storag...305/index.html
When TCQ becomes a reality in IDE drives, they''ll have a fighting
chance, but the slower seek times and rotational speeds will still
do them in.
Also, does an 8MB cache *really* make that much of a difference?
After all, it can only cache 0.0067% of a 120GB drive, and 0.00267%
of the new 300GB disks.
Speaking of which, that 300GB HDD sounds like a dream for near-
line storage, and even for nightly backups, if it is ever put in
SBB-type packaging.
http://www20.tomshardware.com/storag...008/index.html
Imagine a scheme where you rapidly pg_dump to the 300GB drive,
then, at leisure, tar the dump file to tape. Stripe a few together,
and keep a month of backups on-line for quick recovery, along with
the tape archives, in case the stripeset gets wasted, too.
"Ron Johnson" <ro***********@cox.net> wrote in message
news:1066837102.12532.176.camel@haggis...
http://hardware.devchannel.org/hardw...9.shtml?tid=20
&tid = 38& tid = 49
http://hardware.devchannel.org/hardw...9.shtml?tid=20
&tid=38&tid=49
-
--------- -------------------------------------------------- ------
Ron Johnson，Jr。 ro ***** ******@cox.net
美国路易斯安那州杰斐逊
冒险是无能的标志
斯蒂芬森，伟大的极地探险家
---------------------------（播出结束） ---------------------------
提示4：不要'杀'-9'' postmaster
--
-----------------------------------------------------------------
Ron Johnson, Jr. ro***********@cox.net
Jefferson, LA USA
"Adventure is a sign of incompetence"
Stephanson, great polar explorer
---------------------------(end of broadcast)---------------------------
TIP 4: Don''t ''kill -9'' the postmaster
我刚刚在10K SCSI驱动器和7200 RPM IDE上运行了一些基准测试
驱动器：
http://fsbench.netnation.com/
结果差异很大，似乎是文件系统你使用
可以产生巨大的差异。
SCSI明显更快，但性能提升20％，性能提高5倍
$ b我认为$ b只适用于很小比例的人。
周三，2003-10-22 09:01，Stephen写道：
I just ran some benchmarks against a 10K SCSI drive and 7200 RPM IDE
drive here:
http://fsbench.netnation.com/
The results vary quite a bit, and it seems the file system you use
can make a huge difference.
SCSI is obviously faster, but a 20% performance gain for 5x the cost is
only worth it for a very small percentage of people, I would think.
On Wed, 2003-10-22 at 09:01, Stephen wrote:
对IDE的SCSI改进似乎在测试中被高估了。我希望最多可以提高30％。其他评论似乎指出IDE
的表现同样好或更好。
看看汤姆的硬件：
http://www20.tomshardware.com/storag...305/index.html
<斯蒂芬
罗恩约翰逊 <为RO *********** @ cox.net>在消息中写道
新闻：1066837102.12532.176.camel@haggis ...
The SCSI improvement over IDE seems overrated in the test. I would have
expected at most a 30% improvement. Other reviews seem to point out that IDE
performs just as well or better.
See Tom''s hardware:
http://www20.tomshardware.com/storag...305/index.html
Stephen
"Ron Johnson" <ro***********@cox.net> wrote in message
news:1066837102.12532.176.camel@haggis...
http://hardware.devchannel.org/hardw...9.shtml?tid=20
&tid = 38& tid = 49
http://hardware.devchannel.org/hardw...9.shtml?tid=20
&tid=38&tid=49
-
----------------- ------------------------------------------------ <无线电通信Ron Johnson，Jr。 ro *********** @ cox.net
杰斐逊，美国洛杉矶
我不能让你堕胎，但是你可以*让我付钱给孩子18年的支持吗？但是，如果我想要孩子（以及所需的所有费用）* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ??
---------------------------（广播结束）-------- -------------------
提示1：订阅和取消订阅命令转到 ma ******* @ postgresql.org
------------------- --------（广播结束）---------------------------
提示9：策划人将如果您的
加入列的数据类型不匹配，则忽略您选择索引扫描的愿望
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column''s datatypes do not match
-
最好的问候，
Mike Benoit
-------------------------- - （广播结束）---------------------------
提示9：规划师会忽略你的欲望如果您的
加入列的数据类型不匹配，请选择索引扫描
--
Best Regards,
Mike Benoit
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column''s datatypes do not match
这篇关于SCSI与IDE性能测试的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
