Re: w7 vs linux

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