yep thats in accord with my current views on this space.  It seems that when mysql went commercial, certain players in this space immediately converted to PG.  But for my issues, we are dealing with support costs, and it seems that MySQL offers a bit more manageability.  Many suggest PG over MySQL but I can't find any dependable feature matrix to really back up these views.  Unfortunately I think I am dealing more with overzealous PG proselytes than informed users.  In my case there are costs X associated with switching off of MySQL, so PG has to offer something in value comparable to X.

  thanks!

  -jmz


On Wed, Dec 3, 2008 at 3:07 PM, kitepilot@kitepilot.com <kitepilot@kitepilot.com> wrote:
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