OK, thanks everyone, I gather from the responses that postgres performance
won't be an issue for me then. If MS SQL Server and Postgres are in the same
ballpark performance-wise, which seems to be the upshot of your comments, no
problem. I'd only have worried if there was something like the major
difference between the two with more complicated queries. I am puzzled by
the commentor's post to the article, it could be FUD of course but didn't
particularly sound like the commentor was anti pgsql.
Merlin Moncure-2 wrote:
>
> On 11/11/06, novnov <novnovice@gmail.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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
>
--
View this message in context:
http://www.nabble.com/Speed-of-postgres-compared-to-ms-sql%2C-is-this-article-comment-off--tf2614575.html#a7326226
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
