Re: Feature Request --- was: PostgreSQL Performance Tuning

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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD