On 11/23/2012 05:39 PM, Peter Kroon wrote:
Is pgsql faster on linux?Currently I've made an installation on W7 and the converted queries are about 3 times slower then on mssql.
There's still some optimization to do tho...but the current results don't look to good.
In my experience it's somewhat faster on Linux, but I haven't compared extensively on the same hardware.
It's known to be necessary to set shared_buffers lower on Windows for reasons not yet firmly established.
Since you have provided no information about the configuration or hardware, your question isn't much better than "is A faster than B". What's A? What's B?
-- Craig Ringer http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services