Re: Performance of PostgreSQL on Windows vs Linux - Mailing list pgsql-performance

From Jeremy Haile
Subject Re: Performance of PostgreSQL on Windows vs Linux
Date
Msg-id 1167924581.14522.283112867@webmail.messagingengine.com
Whole thread Raw
In response to Re: Performance of PostgreSQL on Windows vs Linux  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance of PostgreSQL on Windows vs Linux
Next
From: "Charles A. Landemaine"
Date:
Subject: PostgreSQL to host e-mail?