Re: Resources for Postgres and MySQL comparison presentation?

> My advice is *not* to try to convince people. Instead, just say,
> "here's the things which PostgreSQL is good for, and the reasons why
> you'd want to use it." Trying to convince people PostgreSQL is
> "better" just gets their back up.

Most effective means of discussing MySQL vs. PostgreSQL is citing
organizations who have moved from MySQL to PostgreSQL and why.

Most people project out their own current database limitations through
association with others who have dealt with similar problems. The
wide range of "why" would be interesting to catalogue but my
experience has been that it's the usual suspects for mysql: table
locking, query planner, slow roll backs, frequent data corruption,
performance of interleaved reads and writes, performance on large data
sets and lack of table inheritance.

A recent surprise motivator for someone to switch was PostgreSQL's
EXPLAIN ANALYZE and the value that provided their engineers in terms
of feedback.

Talking about why someone should is often interpreted as "you made the
wrong decision" and leads to defensiveness.

Good luck! -sc

--
Sean Chittenden
sean(at)chittenden(dot)org