On 11/11/06, novnov <novnovice@xxxxxxxxx> wrote:
I agree with what you say. And I'd still be interesting in hearing of first hand experience with the speed of the two databases from someone who is 'good' at both. The article commentor was obviously not a pgsql expert. I've heard recently that pgsql is as fast as mysql, so it seems odd that ms sql would be faster than pgsql. The actual test, what was use to benchmark, would make a difference of course.
I have a ton of experience with postgresql and mysql, and a fair amount with ms sql. Database performance is hard to nail down, it means different things to different people. However, I it is my personal opinion (backed up with hands-on experience) that PostgreSQL has been pulling away from its major competitors in performance since about 7.4 release. Actually, I think ms sql is a decent database and it's a good choice if you like integration with ms tools. However, like many products I think it topped out in value around year 2000 and am not so sure about the current direction. Note that I only know about yukon by what I've read about it. merlin
