On Fri, Nov 23, 2012 at 2:39 AM, Peter Kroon <plakroon@xxxxxxxxx> 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. Wait first you say pgsql, then you say mssql, so which is it? also single threaded benchmarks don't really mean a lot in the relational db world. for instance, let's say that pgsql runs a query in 100ms with 1 thread, but runs the same query in 110ms with 10 threads. Meanwhile, a db that runs that query in 50ms in a single thread, but takes 500ms for 10 threads isn't scaling all that well. So, what are you trying to do, how are you benchmarking, what kind of performance is important to you? The simpler the benchmark, the more useless it tends to be. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
