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@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD
