Re: PostgreSQL on Linux PC vs MacOS X - Mailing list pgsql-general

From Jim Strickland
Subject Re: PostgreSQL on Linux PC vs MacOS X
Date
Msg-id 418932AB.3060400@americanroamer.com
Whole thread Raw
In response to Re: PostgreSQL on Linux PC vs MacOS X  (Jeff Bohmer <bohmer@visionlink.org>)
Responses Re: PostgreSQL on Linux PC vs MacOS X
List pgsql-general
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


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_xlog
Next
From: Jeff Bohmer
Date:
Subject: Re: PostgreSQL on Linux PC vs MacOS X