There are many possible reasons why to choose one over another, my specific 
one is last...
I have never run personal tests against any, so I'll repeat you what I have 
read over the years: one used to be faster, the other one lacked features 
(depending of who you asked), my understanding is that both are now catching 
up with each other in performance and features. 

The final single reason why I went Postgres was backups.
Back in the day when I did my research (this may have changed) you could not 
take a hot backup in MySQL without purchasing a commercial product, as 
opposite as Postgres that you can simply hot-backup a fully consistent 
database with pgdump. 

Besides, MySQL leans more and more towards a commercial product ala Red Had, 
where Postgres is one of those OSS bastions. 

I go Postgres (with what I "knew" then)
Enrique 

 

Joshua Zeidner writes: 

>   you know I do see many of the advantages with Postgres, but the
> information is patchy.  Can you link me some dependable comparisons?  Many
> claim that MySQL is faster. 
> 
>   Its not for a personal project, I need to provide real justification to
> management.  The PostGIS extension is one of the major gains on the Postgres
> side, but MySQL is catching up there. 
> 
>   -jmz 
> 
> On Wed, Dec 3, 2008 at 2:53 PM, kitepilot@kitepilot.com <
> kitepilot@kitepilot.com> wrote: 
> 
>> Use Postgres...   :) 
>>
>>
>> Joshua Zeidner writes: 
>>
>> > Hello,
>> >
>> >   Has anyone here used MySQL premium services?  Did you think they are a
>> > good value?
>> >
>> > -jmz
>> ---------------------------------------------------
>> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
>> To subscribe, unsubscribe, or to change your mail settings:
>> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss 
>>
---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss