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
