Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 0B52C9FA4CD for ; Wed, 3 Jan 2007 19:46:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 12860-03 for ; Wed, 3 Jan 2007 19:46:26 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from achille.dalibo.net (achille.dalibo.net [212.85.153.230]) by postgresql.org (Postfix) with ESMTP id CB0679FA4CA for ; Wed, 3 Jan 2007 19:46:36 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by achille.dalibo.net (Postfix) with ESMTP id 8F70562CF9; Thu, 4 Jan 2007 00:46:34 +0100 (CET) Received: from achille.dalibo.net ([127.0.0.1]) by localhost (achille [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 16970-04; Thu, 4 Jan 2007 00:46:33 +0100 (CET) Received: from dalistar.local (cac94-7-82-243-27-82.fbx.proxad.net [82.243.27.82]) by achille.dalibo.net (Postfix) with ESMTP id A7E7362CF2; Thu, 4 Jan 2007 00:46:33 +0100 (CET) From: Dimitri Fontaine Organization: dalibo To: pgsql-performance@postgresql.org Subject: Re: Performance of PostgreSQL on Windows vs Linux Date: Thu, 4 Jan 2007 00:46:32 +0100 User-Agent: KMail/1.9.5 Cc: Magnus Hagander , Jeremy Haile References: <1167845064.29222.282952329@webmail.messagingengine.com> <459C39BF.4070403@hagander.net> In-Reply-To: <459C39BF.4070403@hagander.net> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart13906866.lF8DfZzdq4"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200701040046.32453.dim@dalibo.com> X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at dalibo.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/46 X-Sequence-Number: 22647 --nextPart13906866.lF8DfZzdq4 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Le jeudi 4 janvier 2007 00:18, Magnus Hagander a =E9crit=A0: > But to get a good answer on if the difference is > significant enough to matter, you really need to run some kind of simple > benchmark on *your* workload. To easily stress test a couple of servers and compare results on *your*=20 workload, please consider using both pgfouine[1,2] and tsung[3]. The companion tool tsung-ploter[4] (for plotting several results using comm= on=20 graph, hence scales), may also be usefull. [1]: http://pgfouine.projects.postgresql.org/ [2]: http://pgfouine.projects.postgresql.org/tsung.html [3]: http://tsung.erlang-projects.org/ [4]: http://debian.dalibo.org/unstable/tsung-ploter_0.1-1.tar.gz Regards, =2D-=20 Dimitri Fontaine http://www.dalibo.com/ --nextPart13906866.lF8DfZzdq4 Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQBFnEBYl4JX7QVNfwQRAsaTAJ0Qexnf+zEHo40rUq9lSpSB9T0uFwCfcZeA bYa/HZ1gBxJm5LUBdTGTCnY= =plSO -----END PGP SIGNATURE----- --nextPart13906866.lF8DfZzdq4--