On Mon, 30 Apr 2007, Kevin Hunter wrote:
> I recognize that PostgreSQL and MySQL try to address different
> problem-areas, but is this one reason why a lot of people with whom I
> talk prefer MySQL? Because PostgreSQL is so "slooow" out of the box?
It doesn't help, but there are many other differences that are as big or
bigger. Here are a few samples off the top of my head:
1) Performance issues due to MVCC (MySQL fans love to point out how
fast they can do select count(*) from x)
2) Not knowing you have to run vacuum analyze and therefore never seeing a
good query result
3) Unfair comparison of PostgreSQL with robust WAL vs. MySQL+MyISAM on
write-heavy worksloads
These are real issues, which of course stack on top of things like
outdated opinions from older PG releases with performance issues resolved
in the last few years.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD