Top 3 differences between PostgreSQL and MS SQL

The top difference about MSSQL and PostgreSQL is how subquery will be performed. Subquery in PostgreSQL is very slow because they use sequential search in subquery clause. In MSSQL you could easily use this query: SELECT * FROM table_a WHERE id ...

www.petefreitag.com