5 ms·
It varies wildly based on platform, filesystem, hardware, and usage cases. Is your workload write-heavy? Is it more read-heavy than write-heavy? How much query
by gtaylor 14y ago
It varies wildly based on platform, filesystem, hardware, and usage cases.
Is your workload write-heavy? Is it more read-heavy than write-heavy? How much query throughput are you talking?
At the smaller scale, it doesn't really matter. At the larger scale, your app's characteristics determine how much (if any) you are disadvantaged over running a more performant Postgres+Linux combo.
- g8oz 14y agoOk I'll try to be more specific. How much slower is it than SQL Server for a web app that does a 70%-30% split between reading and writing. 10,000 users a day each spending about an hour on it. I've no idea how to measure query output, will have to look that up. Maybe this is more of a Stack Exchange question.
- marcosdumay 14y agoThat still depends. It'll depend on the size of query X number of queries, type of data, coverage of your indexes (what depend on your actual data), and a ton of other factors. I'm not even sure there is somebody out there capable of correctly measuring this. You may need to go with a fast biased study anyway. Also, why are you assuming Postgres is slower?
- Avshalom 14y agoI'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.