Re: Performance of PostgreSQL on Windows vs Linux

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(at)sss(dot)pgh(dot)pa(dot)us> said:
> "Jeremy Haile" <jhaile(at)fastmail(dot)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