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

"Tomi N/A" <hefest@gmail.com> writes:
> 2006/12/4, Ian Harding <harding.ian@gmail.com>:
>> Amen.  When I migrated from MSSQL to PostgreSQL (4 years ago), I found
>> out exactly how seriously MS SQL coddles you when it comes to its "Oh,
>> I know what you really meant" query planning.  I committed some sins
>> MS SQL covered up nicely and PostgreSQL flat out crawled when
>> presented to it.

> I've seen the exact same behaviour last year with pg 8.1 vs. MS SQL 2k.
> It was an unexpected shock, but it's really not that hard to make
> pgsql run much faster.
> There are simply things which pgsql executes painfully slow if you
> don't write them the way the server expects you to.

These sorts of reports would be far more helpful if they contained some
specifics.  What queries does MSSQL do better than Postgres, exactly?

            regards, tom lane