PostgreSQL vs. MySQL, was: MySQL premium services?

[Joshua Zeidner]

  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 at kitepilot.com <
kitepilot at 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 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
> >>
> ---------------------------------------------------
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.PLUG.phoenix.az.us/pipermail/plug-discuss/attachments/20081203/8559b579/attachment.htm