服务器建议 [英] Server recommendations
问题描述
任何人都有链接到良好的数据库服务器盒，但不是机架式安装吗？
包含任何HP，Gateway等等。
- -
你表现得像男人一样，
是一些女人的侮辱，
a来自一个好女人的恭维。 />
---------------------------（广播结束）-------- -------------------
提示9：如果您的
$ b $，计划者将忽略您选择索引扫描的愿望b加入列的数据类型不匹配
糟糕！ ge*****@fireserve.net （Dennis Gearon）在墙上看到喷漆：任何人都有链接到良好的数据库服务器盒，但不是机架式的？
包含任何HP，Gateway等。
它的组件比前面的贴纸更重要
的盒子。
目前，我有戴尔6600 PowerEdge（我认为）这就是模型）
命名为hathi （在我的办公桌下显然是''Hindi forelephant）;
4 Pentium IV'，12 72GB驱动器，8GB RAM，以及其中一个MegaRAID
$ b最近讨论过的$ b控制器。它被用于数据
仓库东西，但我怀疑它会比我们在当地得到的其他任何东西都更好的TP服务器。
它一直在6-7左右分钟运行数据加载，
onproduction TP服务器（2个CPU，只有几个SCSI驱动器），
需要大约2.5小时才能加载。可以说，我应该在
hathi上完成负担。并将生成的数据库的tar包发送到生产，
因为几乎可以肯定会节省几个小时！ （那里有一个很好的理由，不能把它想象成一个理性的答案，但它是一个有趣的想法......）
如果不是那6个粉丝阵列的热量和噪音是什么？b $ b烦扰我周围的每个人，我想把它作为我的桌面盒子，
但是每当我说出这个建议时，每个人都会大力反对:-)。
但是说真的，找一下正确的组件，并确保你有
风扇和电源等物品的冗余。电池
在RAID控制器上支持的缓存只是_gold_，性能方面;
更多内存和更多SCSI磁盘也是一件好事。
-
如果这有用，< http://svcs.affero.net/rm.php?r = cbbrowne>给我打分
http://www.ntlug.org/~ cbbrowne / sap.html
我不是号码！
我是个自由人！
< blockquote> Christopher Browne写道：
哎呀！人们看到 ge*****@fireserve.net （Dennis Gearon）喷涂在墙上：
任何人都有链接到良好的数据库服务器盒，但不是机架式的？
包含任何HP，Gateway等。
它的组件比盒子前面的贴纸更重要。
目前，我有戴尔6600 PowerEdge（我认为这是模型）
命名为hathi （显然那是'Hindi forelephant）在我的桌子下面;
4 Pentium IV'，12 72GB驱动器，8GB RAM，以及最近讨论过的那些MegaRAID
控制器之一。它被用于数据仓库。东西，但我怀疑它会比我们在当地得到的任何其他东西都更好。>
Heh .." hathi"这是非常正确的描述... :-)
从我在postgresql列表上看到的内容来看，似乎基于opteron的机器是好的b $ b做得相当不错作为具有正确类型磁盘的数据库服务器。您可以
查看数据库服务器的任何此类机器..
查看此内容..
http://www.polywell.com/us/rackservers/poly1u2c.asp
http://www.opteronics.com/opteron-servers.htm
IMO他们可以成为更好的数据库机器。获得一个64位的Linux内核和
运行32位postgresql。应该像魅力一样......
HTH
Shridhar
- --------------------------（广播结束）------------------- --------
提示5：您是否检查过我们广泛的常见问题解答？
http://www.postgresql.org/docs/faqs/FAQ.html
On Fri，2003-10-03 at 10:37，Shridhar Daithankar写道：Christopher Browne写道：
哎呀！ ge*****@fireserve.net （Dennis Gearon）在墙上看到喷漆：
[snip]从我在postgresql列表中看到的内容来看，似乎基于opteron的机器作为具有正确类型磁盘的数据库服务器做得相当不错。你可以看看任何这样的数据库服务器机器。
检查这个..
http://www.polywell.com/us/rackservers/poly1u2c.asp
http://www.opteronics.com/opteron-servers.htm
IMO他们可以成为更好的数据库机器。得到64位Linux内核并运行32位postgresql。应该像魅力一样工作..
为什么不在64位内核上运行64位PG？一堆发行版
本月将发布对AMD64的支持。
-
------- -------------------------------------------------- --------
Ron Johnson，Jr。 ro *** ********@cox.net
美国路易斯安那州杰斐逊
所有人都应该免费获取知识。 ;
Harcourt Fenton Mudd，星际迷航：TOS，我，Mudd
------------------ ---------（广播结束）---------------------------
提示6：您是否搜索了我们的列表档案？
http：//archives.postgresql .org
Anyone got links to good db server boxes, not rackmount though?
Include any for HP, Gateway, etc.
--
"You are behaving like a man",
is an insult from some women,
a compliment from a good woman.
---------------------------(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
Oops! ge*****@fireserve.net (Dennis Gearon) was seen spray-painting on a wall:Anyone got links to good db server boxes, not rackmount though?
Include any for HP, Gateway, etc.
It''s the components that matter moreso than the sticker on the front
of the box.
Presently, I have a Dell 6600 PowerEdge (I think that''s the model)
named "hathi" (apparently that''s Hindi for "elephant") under my desk;
4 Pentium IV''s, 12 72GB drives, 8GB RAM, and one of those MegaRAID
controllers that has been discussed lately. It''s being used for "data
warehouse" stuff, but I suspect it would make a better TP server than
anything else we''ve got locally.
It was consistently taking about 6-7 minutes to run a data load that,
on the "production" TP server (2 CPUs, only a couple SCSI drives),
took about 2.5h to load. Arguably, I should have done the load on
"hathi," and FTPed a tarball of the resulting database to production,
as that almost certainly would have saved a couple of hours! (There
were good reasons to not imagine that as a rational answer, but it''s a
fun idea...)
If it weren''t that the heat and the noise of the array of 6 fans was
annoying everyone around me, I''d like to keep it as my desktop box,
but any time I voice the suggestion, everyone objects vigorously :-).
But seriously, look for the right components, and make sure you have
goodly redundancy of things like fans and power supplies. Battery
backed cache on a RAID controller is just _gold_, performance-wise;
more RAM and more SCSI disks are always a nice thing too.
--
If this was helpful, <http://svcs.affero.net/rm.php?r=cbbrowne> rate me
http://www.ntlug.org/~cbbrowne/sap.html
I am not a number!
I am a free man!
Christopher Browne wrote:
Oops! ge*****@fireserve.net (Dennis Gearon) was seen spray-painting on a wall:Anyone got links to good db server boxes, not rackmount though?
Include any for HP, Gateway, etc.
It''s the components that matter moreso than the sticker on the front
of the box.
Presently, I have a Dell 6600 PowerEdge (I think that''s the model)
named "hathi" (apparently that''s Hindi for "elephant") under my desk;
4 Pentium IV''s, 12 72GB drives, 8GB RAM, and one of those MegaRAID
controllers that has been discussed lately. It''s being used for "data
warehouse" stuff, but I suspect it would make a better TP server than
anything else we''ve got locally.
Heh.. "hathi" is quite right description for that..:-)
From what I read on postgresql lists, it seems that opteron based machines are
doing quite a good job as database server with right kind of disk. You could
look at any such machine for database server..
Check this..
http://www.polywell.com/us/rackservers/poly1u2c.asp
http://www.opteronics.com/opteron-servers.htm
IMO they could be better machine for databases. Get a 64 bit linux kernel and
run 32 bit postgresql on it. Should work like a charm..
HTH
Shridhar
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
On Fri, 2003-10-03 at 10:37, Shridhar Daithankar wrote:Christopher Browne wrote:Oops! ge*****@fireserve.net (Dennis Gearon) was seen spray-painting on a wall:[snip] From what I read on postgresql lists, it seems that opteron based machines are
doing quite a good job as database server with right kind of disk. You could
look at any such machine for database server..
Check this..
http://www.polywell.com/us/rackservers/poly1u2c.asp
http://www.opteronics.com/opteron-servers.htm
IMO they could be better machine for databases. Get a 64 bit linux kernel and
run 32 bit postgresql on it. Should work like a charm..
Why not run 64-bit PG on the 64-bit kernel? A bunch of distros
are releasing support for the AMD64 this month.
--
-----------------------------------------------------------------
Ron Johnson, Jr. ro***********@cox.net
Jefferson, LA USA
"Knowledge should be free for all."
Harcourt Fenton Mudd, Star Trek:TOS, "I, Mudd"
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
这篇关于服务器建议的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
