Linux PC上的PostgreSQL与MacOS X [英] PostgreSQL on Linux PC vs MacOS X
问题描述
我们目前正在使用4D在Mac上运行数据密集型Web服务。
我们网站的开发人员正在考虑将此Web服务转换为
PostgreSQL。我们将在
位置备份我们的三台生产服务器。开发人员建议我购买2GB双处理器，处理器G5，2GB到4GB RAM。他们说这个
配置能够轻松运行所有三个生产服务器的副本。我的问题是：有没有人有经验比较G5 Mac上的PostgreSQL与运行Linux的PC相比的性能？可以
有人告诉我，如果在一个
平台上运行PostgreSQL有什么好处。任何可以帮助我做出最佳决定的事情都会受到赞赏。
-
James Strickland - MCP
IT经理
美国漫游者
901-377-8585
http://www.americanroamer.com
------------------- --------（广播结束）---------------------------
提示6 ：您是否搜索了我们的列表档案？
http：//archives.postgresql。组织
We currently are running a data intensive web service on a Mac using 4D.
The developers of our site are looking at converting this web service to
PostgreSQL. We will have a backup of our three production servers at our
location. The developers are recommending that I purchase a 2GHz Dual
Processor G5 with between 2GB and 4 GB RAM. They say that this
configuration would be able to easily run a copy of all three production
servers. My question is: has anybody had any experience comparing the
performance of PostgreSQL on a G5 Mac versus a PC running Linux? Can
anyone tell me if there are any benefits of running PostgreSQL on one
platform over the other. Anything that can help me make the best
decision would be appreciated.
--
James Strickland - MCP
IT Manager
American Roamer
901-377-8585
http://www.americanroamer.com
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
推荐答案
我们在OS X和Linux上使用PostgreSQL 7.x 。我们曾经在
生产中运行OS X，但由于很多问题，我们转而使用Linux。 OS X
根本不稳定，特别是在负载下。在负载与否之下，这也是一个糟糕的
表演者。
在我的测试中，P3 / 800,512MB RAM（100MHz总线）始终更快<对于我们的
应用程序，所有查询都需要
，而不是G4 / 1.25GHz，1.5GB RAM（266MHz总线）。两台机器都有单个IDE驱动器。
另一件需要考虑的事情是你只能使用带有
Apple硬件的ATA驱动器。 Apple无法使用SCSI，而且在OS X下，SCSI设备支持非常差的支持。如果使用ATA驱动器的服务器在错误的时间下降了
，则可能会丢失数据。这件事发生在去年我们的生产OS X服务器上。
。 UPS电池延长了停电时间，因为关机脚本没有停止服务器的时间，我们不得不从之前的备份中恢复。有关
的详细信息，为什么ATA驱动器会发生这种情况，请参阅此主题：
< http://archives.postgresql.org/pgsql-general /2003-10/msg01343.php>
总的来说，PostgreSQL在Linux上坚如磐石，速度非常快，而且无头痛。从OS X完全改变。我们的主要产品
PostgreSQL服务器现已上架234天。在那段时间里，PostgreSQL的停机时间仅为计划升级。
作为旁注，我们在运行多个问题时也遇到了重大问题-th $
OS X上的
服务器在Linux上运行良好（稳定且快得多）。
- Jeff
We use PostgreSQL 7.x on both OS X and Linux. We used to run OS X in
production, but due to numerous problems we switched to Linux. OS X
was not stable at all, especially under load. It was also a poor
performer under load or not.
In my tests, a P3/800, 512MB RAM (100MHz bus) was consistently faster
at all queries than a G4/1.25GHz, 1.5GB RAM (266MHz bus) for our
application. Both machines had single IDE drives.
Another thing to consider is that you can only get ATA drives with
Apple hardware. SCSI is not available from Apple, and SCSI devices
have very poor support under OS X. If a server with ATA drives goes
down at the wrong time, you can lose data. This happened to us with
our production OS X server last year. An extended power outage ran
out the UPS battery, the shutdown script did not stop the server in
time, and we had to restore from an earlier backup. For details on
why this can happen with ATA drives, see this thread:
<http://archives.postgresql.org/pgsql-general/2003-10/msg01343.php>
Overall, PostgreSQL has been rock solid, very fast, and headache-free
on Linux. A complete change from OS X. Our main production
PostgreSQL server has been up for 234 days now. In that period, the
only downtime for PostgreSQL has been for planned upgrades.
As a side note, we''ve also had major problems running multi-threaded
servers on OS X which run great (stable and much, much faster) on
Linux.
- Jeff
我们目前正在使用
4D在Mac上运行数据密集型Web服务。我们网站的开发人员正在考虑将此网站服务转换为PostgreSQL。我们将在我们的位置备份我们的三台生产服务器。开发人员建议我购买一个2GB到4GB RAM的2GHz双处理器G5。
他们说这个配置能够轻松运行所有三个生产服务器的副本。我的问题是：有没有人比较运行Linux的PC上的PostgreSQL在G5 Mac上的性能？任何人都可以告诉我在一个平台上运行PostgreSQL是否有任何好处。
任何可以帮助我做出最佳决定的事情都将受到赞赏。
-
James Strickland - MCP
美国漫游者
美国漫游者
901-377-8585
http://www.americanroamer.com
---------------- -----------（广播结束）---------------------------
提示6：您是否搜索过我们的列表档案？
http://archives.postgresql.org
-
Jeff Bohmer
VisionLink，Inc。
_________________________________
303.402.0170 x121
http：// www.visionlink.org/
_________________________________
人。工具。更改。社区。
---------------------------（播出结束）---- -----------------------
提示5：您查看了我们广泛的常见问题解答吗？
< a rel =nofollowhref =http://www.postgresql.org/docs/faqs/FAQ.htmltarget =_ blank> http://www.postgresql.org/docs/faqs/FAQ.html
--
Jeff Bohmer
VisionLink, Inc.
_________________________________
303.402.0170 x121
http://www.visionlink.org/
_________________________________
People. Tools. Change. Community.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
我们在OS X和Linux上都使用PostgreSQL 7.x.我们曾经在
生产中运行OS X，但由于很多问题，我们转而使用Linux。 OS X
根本不稳定，特别是在负载下。在负载与否之下，这也是一个糟糕的
表演者。
在我的测试中，P3 / 800,512MB RAM（100MHz总线）始终更快<对于我们的
应用程序，所有查询都需要
，而不是G4 / 1.25GHz，1.5GB RAM（266MHz总线）。两台机器都有单个IDE驱动器。
另一件需要考虑的事情是你只能使用带有
Apple硬件的ATA驱动器。 Apple无法使用SCSI，而且在OS X下，SCSI设备支持非常差的支持。如果使用ATA驱动器的服务器在错误的时间下降了
，则可能会丢失数据。这件事发生在去年我们的生产OS X服务器上。
。 UPS电池延长了停电时间，因为关机脚本没有停止服务器的时间，我们不得不从之前的备份中恢复。有关
的详细信息，为什么ATA驱动器会发生这种情况，请参阅此主题：
< http://archives.postgresql.org/pgsql-general /2003-10/msg01343.php>
总的来说，PostgreSQL在Linux上坚如磐石，速度非常快，而且无头痛。从OS X完全改变。我们的主要产品
PostgreSQL服务器现已上架234天。在那段时间里，PostgreSQL的停机时间仅为计划升级。
作为旁注，我们在运行多个问题时也遇到了重大问题-th $
OS X上的
服务器在Linux上运行良好（稳定且快得多）。
- Jeff
We use PostgreSQL 7.x on both OS X and Linux. We used to run OS X in
production, but due to numerous problems we switched to Linux. OS X
was not stable at all, especially under load. It was also a poor
performer under load or not.
In my tests, a P3/800, 512MB RAM (100MHz bus) was consistently faster
at all queries than a G4/1.25GHz, 1.5GB RAM (266MHz bus) for our
application. Both machines had single IDE drives.
Another thing to consider is that you can only get ATA drives with
Apple hardware. SCSI is not available from Apple, and SCSI devices
have very poor support under OS X. If a server with ATA drives goes
down at the wrong time, you can lose data. This happened to us with
our production OS X server last year. An extended power outage ran
out the UPS battery, the shutdown script did not stop the server in
time, and we had to restore from an earlier backup. For details on
why this can happen with ATA drives, see this thread:
<http://archives.postgresql.org/pgsql-general/2003-10/msg01343.php>
Overall, PostgreSQL has been rock solid, very fast, and headache-free
on Linux. A complete change from OS X. Our main production
PostgreSQL server has been up for 234 days now. In that period, the
only downtime for PostgreSQL has been for planned upgrades.
As a side note, we''ve also had major problems running multi-threaded
servers on OS X which run great (stable and much, much faster) on
Linux.
- Jeff
我们目前正在使用
4D在Mac上运行数据密集型Web服务。我们网站的开发人员正在考虑将此网站服务转换为PostgreSQL。我们将在我们的位置备份我们的三台生产服务器。开发人员建议我购买一个2GB到4GB RAM的2GHz双处理器G5。
他们说这个配置能够轻松运行所有三个生产服务器的副本。我的问题是：有没有人比较运行Linux的PC上的PostgreSQL在G5 Mac上的性能？任何人都可以告诉我在一个平台上运行PostgreSQL是否有任何好处。
任何可以帮助我做出最佳决定的事情都将受到赞赏。
-
James Strickland - MCP
美国漫游者
美国漫游者
901-377-8585
http://www.americanroamer.com
---------------- -----------（广播结束）---------------------------
提示6：您是否搜索过我们的列表档案？
http://archives.postgresql.org
-
Jeff Bohmer
VisionLink，Inc。
_________________________________
303.402.0170 x121
http：// www.visionlink.org/
_________________________________
人。工具。更改。社区。
---------------------------（播出结束）---- -----------------------
提示5：您查看了我们广泛的常见问题解答吗？
< a rel =nofollowhref =http://www.postgresql.org/docs/faqs/FAQ.htmltarget =_ blank> http://www.postgresql.org/docs/faqs/FAQ.html
--
Jeff Bohmer
VisionLink, Inc.
_________________________________
303.402.0170 x121
http://www.visionlink.org/
_________________________________
People. Tools. Change. Community.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
我注意到你在G4上运行了PostgreSQL。什么版本的OS X是你运行的
？是否有可能使用
更新的G5处理器解决您遇到的问题？
Jeff Bohmer写道：
I noticed you ran PostgreSQL on a G4. What version of OS X were you
running? Is it possible the issues you were facing were fixed with the
newer G5 processor?
Jeff Bohmer wrote:
我们在OS X和Linux上使用PostgreSQL 7.x.我们曾经在生产中运行OS X，但由于很多问题，我们转而使用Linux。 OS X
根本不稳定，特别是在负载下。在负载与否之下，它也是一个表现不佳的人。
在我的测试中，P3 / 800,512MB RAM（100MHz总线）在所有查询中始终比G4 / 1.25GHz，1.5GB RAM（266MHz总线）用于我们的
应用程序。两台机器都有单个IDE驱动器。
另一件需要考虑的事情是，您只能使用Apple硬件获得ATA驱动器。 Apple无法使用SCSI，而且在OS X下，SCSI设备的支持非常差。如果带有ATA驱动器的服务器在错误的时间内关闭，则可能会丢失数据。去年我们的生产OS X服务器发生了这种情况。延长的电力中断运行UPS电池，关机脚本没有停止服务器的时间，我们不得不从早期的备份恢复。有关为什么ATA驱动器会发生这种情况的详细信息，请参阅此主题：
< http://archives.postgresql.org/pgsql-general/2003-10/msg01343.php> ;总的来说，PostgreSQL在Linux上坚如磐石，速度非常快，而且非常无痛。从OS X完全改变。我们的主要产品是PostgreSQL服务器已经运行了234天。在那个时期，PostgreSQL只有停机时间用于计划升级。
作为旁注，我们在运行多线程服务器时遇到了重大问题。 OS X在Linux上运行良好（稳定且快得多）。
- Jeff
We use PostgreSQL 7.x on both OS X and Linux. We used to run OS X in
production, but due to numerous problems we switched to Linux. OS X
was not stable at all, especially under load. It was also a poor
performer under load or not.
In my tests, a P3/800, 512MB RAM (100MHz bus) was consistently faster
at all queries than a G4/1.25GHz, 1.5GB RAM (266MHz bus) for our
application. Both machines had single IDE drives.
Another thing to consider is that you can only get ATA drives with
Apple hardware. SCSI is not available from Apple, and SCSI devices
have very poor support under OS X. If a server with ATA drives goes
down at the wrong time, you can lose data. This happened to us with
our production OS X server last year. An extended power outage ran
out the UPS battery, the shutdown script did not stop the server in
time, and we had to restore from an earlier backup. For details on
why this can happen with ATA drives, see this thread:
<http://archives.postgresql.org/pgsql-general/2003-10/msg01343.php>
Overall, PostgreSQL has been rock solid, very fast, and headache-free
on Linux. A complete change from OS X. Our main production
PostgreSQL server has been up for 234 days now. In that period, the
only downtime for PostgreSQL has been for planned upgrades.
As a side note, we''ve also had major problems running multi-threaded
servers on OS X which run great (stable and much, much faster) on Linux.
- Jeff
我们目前正在Mac上运行数据密集型Web服务使用
4D。我们网站的开发人员正在考虑将此网站服务转换为PostgreSQL。我们将在我们的位置备份我们的三台生产服务器。开发人员建议我购买2GB和4GB RAM的2GHz双处理器G5。他们说这个配置能够轻松运行所有三个生产服务器的副本。我的问题是：有没有人比较G5 Mac上的PostgreSQL与运行Linux的PC的性能有什么经验？任何人都可以告诉我，在一个平台上运行PostgreSQL是否有任何好处。任何可以帮助我做出最佳决定的事情都将受到赞赏。
-
James Strickland - MCP
美国漫游者
美国漫游者> 901-377-8585
http://www.americanroamer.com
---------------------------（广播结束）----------- ----------------
提示6：您是否搜索了我们的列表档案？
http://archives.postgresql.org
We currently are running a data intensive web service on a Mac using
4D. The developers of our site are looking at converting this web
service to PostgreSQL. We will have a backup of our three production
servers at our location. The developers are recommending that I
purchase a 2GHz Dual Processor G5 with between 2GB and 4 GB RAM. They
say that this configuration would be able to easily run a copy of all
three production servers. My question is: has anybody had any
experience comparing the performance of PostgreSQL on a G5 Mac versus
a PC running Linux? Can anyone tell me if there are any benefits of
running PostgreSQL on one platform over the other. Anything that can
help me make the best decision would be appreciated.
--
James Strickland - MCP
IT Manager
American Roamer
901-377-8585
http://www.americanroamer.com
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
-
James Strickland - MCP
IT经理
美国漫游者
901-377-8585
http://www.americanroamer.com
- --------------------------（广播结束）------------------- --------
提示9：如果您的
joi，计划员将无视您选择索引扫描的愿望ning column'的数据类型不匹配
--
James Strickland - MCP
IT Manager
American Roamer
901-377-8585
http://www.americanroamer.com
---------------------------(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
这篇关于Linux PC上的PostgreSQL与MacOS X的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
