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
(text/plain)