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:
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
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 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
