From: Jim C. Nasby <jim@nasby.net>
To: Jeremy Haile <jhaile@fastmail.fm>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance of PostgreSQL on Windows vs Linux
Date: Wed, 10 Jan 2007 14:15:26 -0600
Message-ID: <20070110201526.GS12217@nasby.net> (raw)
In-Reply-To: <1167845064.29222.282952329@webmail.messagingengine.com>
References: <1167845064.29222.282952329@webmail.messagingengine.com>
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jim@nasby.net, jhaile@fastmail.fm
Subject: Re: Performance of PostgreSQL on Windows vs Linux
In-Reply-To: <20070110201526.GS12217@nasby.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox