Quad Xeon与Dual Itanium [英] Quad Xeon vs. Dual Itanium
问题描述
大家好。
我需要升级我的双Xeon PostgreSQL引擎。
假设类似的内存和磁盘子系统，我正在考虑使用Quad
Xeon系统而不是PostgreSQL的Dual Itanium。我相信
PostgreSQL代码是针对32位编写的，并没有针对64位
Itanium cpu进行优化。这让我觉得Xeon系统会更好。
选择。
你们有没有想过：
1.直接表现能力
2.价格/性能
如果您有任何反馈，我将不胜感激。
... .john
---------------------------（广播结束）-------- -------------------
提示1：订阅和取消订阅命令转到 ma ******* @ postgresql.org
John Gibson < gi*@edgate.com>写道：
假设存在类似的内存和磁盘子系统，我正在考虑使用Quad
Xeon系统而不是PostgreSQL的Dual Itanium。我相信PostgreSQL代码是针对32位编写的，并没有针对64位的Itanium cpu进行优化。这让我觉得Xeon系统将是一个更好的选择。
Postgres在许多64位系统上运行，包括UltraSPARC，MIPS和
Alpha，以及Intel和AMD产品。是什么让你觉得它'
''没有优化''？
-Doug
- --------------------------（广播结束）------------------- --------
提示7：别忘了增加免费空间地图设置
你好清单，
我正在设计一个plperlu函数，我想知道对外部库使用
使用语句的范围。我在文档或邮件档案中找不到任何信息
，所以任何信息
都会非常感激。
该函数旨在用作select语句的一部分：
选择foo，my_function（bar）为baz from table baz> some_value
由baz订购
该功能使用一个外部模块来完成大量的重击
。我想知道的是，该功能是否必须为每一行重新加载
外部模块，或者是足够智能，只为整个查询加载一次
？在另一个极端，我希望它为每个查询重新加载外部模块，因为我希望是动态重写其中一个模块的
外部模块需要。
-Stephen
------------------------ ---（播出结束）---------------------------
提示7：不要忘记增加你的免费空间地图设置
-----原始消息-----
来自：< a href =mailto：pg ***************** @ postgresql.org> pg ***************** @ postgresql .org
[mailto：pg ***************** @ postgresql.org]代表Doug McNaught
已发送：2004年2月9日星期一上午10:44
致：John Gibson
Cc： pg *********** @ postgresql.org
主题：Re：[GENERAL] Quad Xeon vs 。双安腾
John Gibson< gi*@edgate.com>写道：
假设存在类似的内存和磁盘子系统，我正在考虑使用Quad
Xeon系统而不是PostgreSQL的Dual Itanium。我相信PostgreSQL代码是针对32位编写的，并没有针对64位的Itanium cpu进行优化。这让我觉得Xeon系统将是一个更好的选择。
Postgres在许多64位系统上运行，包括UltraSPARC，MIPS和
Alpha，以及Intel和AMD产品。是什么让你认为它'
''未优化''？
-Doug
----- --------------------
我能看到它没有针对64位优化的唯一方法是使用
32bit二进制文件就可以了，唯一可行的方法就是我认为新的
amd芯片，或者itanium也会运行32位应用程序吗？
Rob
---------------------------（播出结束） - -------------------------
提示6：您是否搜索了我们的列表档案？
http://archives.postgresql.org
Hi, all.
I need to upgrade my dual Xeon PostgreSQL engine.
Assuming similar memory and disk sub-systems, I am considering a Quad
Xeon system vs. a Dual Itanium for PostgreSQL. I believe that the
PostgreSQL code is written for 32 bit and not optimized for the 64 bit
Itanium cpu. That makes me think that the Xeon system would be a better
choice.
Do any of you have thoughts on:
1. Straight performance capability
2. Price/Performance
I would appreciate any feedback you might have.
....john
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org
John Gibson <gi*@edgate.com> writes:
Assuming similar memory and disk sub-systems, I am considering a Quad
Xeon system vs. a Dual Itanium for PostgreSQL. I believe that the
PostgreSQL code is written for 32 bit and not optimized for the 64 bit
Itanium cpu. That makes me think that the Xeon system would be a
better choice.
Postgres runs on many 64-bit systems, including UltraSPARC, MIPS, and
Alpha, plus the Intel and AMD offerings. What makes you think it''s
''not optimized''?
-Doug
---------------------------(end of broadcast)---------------------------
TIP 7: don''t forget to increase your free space map settings
Hello list,
I''m designing a plperlu function and i was wondering about scoping on
use statements for external libraries. I couldn''t find any information
on it in the documentation or in the mail archives, so any information
would be much appreciated.
The function is intended to be used as part of a select statement:
select foo,my_function(bar) as baz from table where baz > some_value
order by baz
And the function uses an external module to do much of the heavy
lifting. What I''m wondering is will the function have to reload the
external module for every row, or is plperlu smart enough to only load
it once for the entire query? In the other extreme, I''m hoping that it
does reload the external module for each query, as I expect to be
dynamically rewriting one of the modules that that external module requires.
-Stephen
---------------------------(end of broadcast)---------------------------
TIP 7: don''t forget to increase your free space map settings
-----Original Message-----
From: pg*****************@postgresql.org
[mailto:pg*****************@postgresql.org] On Behalf Of Doug McNaught
Sent: Monday, February 09, 2004 10:44 AM
To: John Gibson
Cc: pg***********@postgresql.org
Subject: Re: [GENERAL] Quad Xeon vs. Dual Itanium
John Gibson <gi*@edgate.com> writes:
Assuming similar memory and disk sub-systems, I am considering a Quad
Xeon system vs. a Dual Itanium for PostgreSQL. I believe that the
PostgreSQL code is written for 32 bit and not optimized for the 64 bit
Itanium cpu. That makes me think that the Xeon system would be a
better choice.
Postgres runs on many 64-bit systems, including UltraSPARC, MIPS, and
Alpha, plus the Intel and AMD offerings. What makes you think it''s
''not optimized''?
-Doug
-------------------------
The only way I can see that its not optimized for 64 bit would be to use
32bit binaries on it, and the only way that can even happen is on the new
amd chips I believe, or will itanium run 32bit apps also?
Rob
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
这篇关于Quad Xeon与Dual Itanium的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
