Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 892BB9FA43C for ; Thu, 4 Jan 2007 10:31:16 -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 13723-06 for ; Thu, 4 Jan 2007 10:30:06 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from out4.smtp.messagingengine.com (out4.smtp.messagingengine.com [66.111.4.28]) by postgresql.org (Postfix) with ESMTP id 6CFFB9FA0EF for ; Thu, 4 Jan 2007 10:30:24 -0400 (AST) Received: from out1.internal (unknown [10.202.2.149]) by out1.messagingengine.com (Postfix) with ESMTP id AA3895B30E for ; Thu, 4 Jan 2007 09:27:46 -0500 (EST) Received: from web2.messagingengine.com ([10.202.2.211]) by out1.internal (MEProxy); Thu, 04 Jan 2007 09:27:46 -0500 Received: by web2.messagingengine.com (Postfix, from userid 99) id 97E912A7F8; Thu, 4 Jan 2007 09:27:46 -0500 (EST) Message-Id: <1167920866.6081.283102447@webmail.messagingengine.com> X-Sasl-Enc: A1YIzkOcH2Z9hF6X44TH5f7Q3TKSMKj/MKbBXXrB0UsR 1167920866 From: "Jeremy Haile" To: pgsql-performance@postgresql.org Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="ISO-8859-1" MIME-Version: 1.0 X-Mailer: MessagingEngine.com Webmail Interface References: <1167845064.29222.282952329@webmail.messagingengine.com> <459C39BF.4070403@hagander.net> <200701040046.32453.dim@dalibo.com> Subject: Re: Performance of PostgreSQL on Windows vs Linux In-Reply-To: <200701040046.32453.dim@dalibo.com> Date: Thu, 04 Jan 2007 09:27:46 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/52 X-Sequence-Number: 22653 Thanks for the recommendations. I wasn't familiar with those packages! On Thu, 4 Jan 2007 00:46:32 +0100, "Dimitri Fontaine" said: > Le jeudi 4 janvier 2007 00:18, Magnus Hagander a =E9crit : > > 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. >=20 > 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]. >=20 > The companion tool tsung-ploter[4] (for plotting several results using > common=20 > graph, hence scales), may also be usefull. >=20 > [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 >=20 > Regards, > --=20 > Dimitri Fontaine > http://www.dalibo.com/