> These sorts of reports would be far more helpful if they contained some
> specifics. What queries does MSSQL do better than Postgres, exactly?
Our OR-patch was inspired by our customer migrating from MS SQL to postgres.
Next, index support of IS NULL. And, there is a huge difference in performance
for queries like
select * from a,b where a.f = b.f or ( a.f is null and b.f is null)
NULL support is fast in MS SQL because MS SQL doesn't follow SQL standard: index
in MS SQL believes that (NULL = NULL) is true.
--
Teodor Sigaev E-mail: teodor@sigaev.ru
WWW: http://www.sigaev.ru/