Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 8BA549FB26B for ; Wed, 10 Jan 2007 16:15:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 43711-05 for ; Wed, 10 Jan 2007 16:15:30 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 18DDF9FB269 for ; Wed, 10 Jan 2007 16:15:29 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 0A03156442; Wed, 10 Jan 2007 14:15:29 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Wed, 10 Jan 2007 14:15:26 -0600 Date: Wed, 10 Jan 2007 14:15:26 -0600 From: "Jim C. Nasby" To: Jeremy Haile Cc: pgsql-performance@postgresql.org Subject: Re: Performance of PostgreSQL on Windows vs Linux Message-ID: <20070110201526.GS12217@nasby.net> References: <1167845064.29222.282952329@webmail.messagingengine.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1167845064.29222.282952329@webmail.messagingengine.com> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070110:jhaile@fastmail.fm::r1rTEGCRLPuK78F/:0000000000000000000 0000000000000000000000008zRT X-Hashcash: 1:20:070110:pgsql-performance@postgresql.org::vC4uB4Z817n+wExO:00000 0000000000000000000000000XUS X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/142 X-Sequence-Number: 22743 On Wed, Jan 03, 2007 at 12:24:24PM -0500, Jeremy Haile wrote: > I am sure that this has been discussed before, but I can't seem to find > any recent posts. (I am running PostgreSQL 8.2) > > I have always ran PostgreSQL on Linux in the past, but the company I am > currently working for uses Windows on all of their servers. I don't > have the luxury right now of running my own benchmarks on the two OSes, > but wanted to know if anyone else has done a performance comparison. Is > there any significant differences? One thing to consider... I've seen a case or two where pgbench running on windows with HyperThreading enabled was actually faster than with it turned off. (General experience has been that HT hurts PostgreSQL). I suspect that the windows kernel may have features that allow it to better utilize HT than linux. Of course if you don't have HT... it doesn't matter. :) -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)