Message-Id: <1167924581.14522.283112867@webmail.messagingengine.com>
From: "Jeremy Haile" <jhaile@fastmail.fm>
To: pgsql-performance@postgresql.org
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="ISO-8859-1"
MIME-Version: 1.0
References: <1167845064.29222.282952329@webmail.messagingengine.com>
	<459C39BF.4070403@hagander.net>
	<1167922013.8482.283102539@webmail.messagingengine.com>
	<17034.1167924231@sss.pgh.pa.us>
Subject: Re: Performance of PostgreSQL on Windows vs Linux
In-Reply-To: <17034.1167924231@sss.pgh.pa.us>
Date: Thu, 04 Jan 2007 10:29:41 -0500

I'm using 8.2.  I don't know when I'll get a chance to run my own
benchmarks.  (I don't currently have access to a Windows and Linux
server with similar hardware/configuration) But when/if I get a chance
to run them, I will post the results here.

Thanks for the feedback.

Jeremy Haile


On Thu, 04 Jan 2007 10:23:51 -0500, "Tom Lane" <tgl@sss.pgh.pa.us> said:
> "Jeremy Haile" <jhaile@fastmail.fm> writes:
> > Thanks for the response!  I know I have to benchmark them to get a real
> > answer.  I am just looking to hear someone say "We benchmarked Linux vs.
> > Windows with similar configuration and hardware and experienced a 25%
> > performance boost in Linux."  or "We benchmarked them and found no
> > significant difference."  
> 
> I've heard anecdotal reports both ways: "there's no difference" and
> "there's a big difference".  So there's no substitute for benchmarking
> your own application.
> 
> I think one big variable in this is which PG version you are testing.
> We've been gradually filing down some of the rough edges in the native
> Windows port, so I'd expect that the performance gap is closing over
> time.  I don't know how close to closed it is in 8.2, but I'd surely
> suggest that you do your benchmarking with 8.2.
> 
> 			regards, tom lane