Re:Top Reasons I like Postgres Over SQL Server
by g8oz on Monday April 08, 2013 @02:33PM
(#5513571)
How does Postgres performance rank on Windows?
[ Parent
| on HN ]
Re:Top Reasons I like Postgres Over SQL Server
by gtaylor on Monday April 08, 2013 @02:40PM
(#5513618)
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.
Ok 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.
Re:Top Reasons I like Postgres Over SQL Server
by marcosdumay on Monday April 08, 2013 @04:01PM
(#5514140)
That 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?
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.