PostgreSQL vs. MySQL, was: MySQL premium services?

[kitepilot at kitepilot.com]

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 at kitepilot.com <
> kitepilot at 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 at lists.plug.phoenix.az.us
>> To subscribe, unsubscribe, or to change your mail settings:
>> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss 
>>