3 ms·
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
by Avshalom 14y ago
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.
- gtaylor 14y agoI 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.
- jeltz 14y agoIndeed, 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.
- spudlyo 14y agoOracle 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.