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

From: novnov <novnovice(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Speed of postgres compared to ms sql, is this
Date: 2006-11-12 01:15:08
Message-ID: 7298762.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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'm hoping someone with a good handle on both databases has direct
experience can chime in here.

Tom Lane-2 wrote:
>
> novnov <novnovice(at)gmail(dot)com> writes:
>> http://www.simple-talk.com/sql/sql-server-2005/sql-server,-postgressql-and-fish-curry/
>> at the bottom of the page is a post by Andrew Clarke that says pgsql is
>> much
>> slower in comparison to ms sql.
>
> With no details, it's hard to rate that as anything but content-free FUD.
>
> I don't doubt that he saw a serious performance differential on whatever
> his test case was, but without seeing the test case it's impossible to
> know why, or whether it would be fixable. Nor do we know what PG
> version he was testing. Given that he mentions Windows 2000, it's not
> unlikely that he was testing a Cygwin port of PG 7.something, in which
> case just moving to an 8.1 native port would help a lot.
>
> Also, given that he mentions that complex joins were bad, it could be
> that he forgot to analyze, or had a corner case where the row estimates
> were bad anyway, or had an outer-join scenario where reordering of
> the outer joins is really essential for performance. (We've fixed the
> latter as of 8.2, I think, but I will agree it's a serious weak spot in
> existing PG releases.) But this is all speculation...
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>

--
View this message in context: http://www.nabble.com/Speed-of-postgres-compared-to-ms-sql%2C-is-this-article-comment-off--tf2614575.html#a7298762
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Rovero 2006-11-12 01:43:23 Re: Speed of postgres compared to ms sql, is this
Previous Message Tom Lane 2006-11-12 00:43:40 Re: Speed of postgres compared to ms sql, is this article/comment off?