Re: Speed of postgres compared to ms sql, is this

On 11/11/06, novnov <novnovice(at)gmail(dot)com> 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