News for hackers. Stuff that matters.
Re:Top Reasons I like Postgres Over SQL Server by Avshalom on Monday April 08, 2013 @04:16PM (#5514245)
I'm not the parent but I sort of operate on the assumption that Windows isn't Postgres primary target when they make optimizations. While SQL Server is not only purely focused on Windows they have have access to knowledge about (and in server editions, probably influence on) the low level internals that Postgres people never will. As pointed out in on of the top comments SQL Server has a bunch of extra junk built in(ish) but still I too would, having not tested anything, assume SS would be faster than Pg on Windows.
Re:Top Reasons I like Postgres Over SQL Server by gtaylor on Monday April 08, 2013 @04:36PM (#5514389)
I think you're correct here. Postgres has had lots of optimization work specifically for Linux and Unix/BSD. The Linux kernel has also had some optimization done to improve hot paths that Postgres hits.

I'm sure the Postgres team has kept an eye on Windows, but I doubt it gets nearly as much attention as the *nix environments.

Re:Top Reasons I like Postgres Over SQL Server by jeltz on Monday April 08, 2013 @05:43PM (#5514837)
Indeed, most of the benchmarking of the core PostgreSQL team is done on Linux. Some of those optimizations also benefit Windows but there is little dedicated performance work for platforms outside Linux as far as I can see from reading the mailing lists.
Re:Top Reasons I like Postgres Over SQL Server by spudlyo on Monday April 08, 2013 @07:18PM (#5515384)
Oracle has spent a lot of effort improving the MySQL's performance and usability on Windows for version 5.5. I believe Oracle would like to take a bite out of MSSQL sales with MySQL.