Re: [PERFORM] Performance of PostgreSQL on Windows vs Linux

2007-01-10 Thread Scott Marlowe
On Wed, 2007-01-10 at 14:15, Jim C. Nasby wrote: > On Wed, Jan 03, 2007 at 12:24:24PM -0500, Jeremy Haile wrote: > > I am sure that this has been discussed before, but I can't seem to find > > any recent posts. (I am running PostgreSQL 8.2) > > > > I have always ran PostgreSQL on Linux in the past

Re: [PERFORM] Performance of PostgreSQL on Windows vs Linux

2007-01-10 Thread Jeremy Haile
Hey Jim - Thanks for the feedback. The server has dual Xeons with HyperThreading enabled - so perhaps I should try disabling it. How much performance boost have you seen by disabling it? Of course, the bottleneck in my case is more on the I/O or RAM side, not the CPU side. Jeremy Haile On W

Re: [PERFORM] Performance of PostgreSQL on Windows vs Linux

2007-01-10 Thread Jim C. Nasby
On Wed, Jan 03, 2007 at 12:24:24PM -0500, Jeremy Haile wrote: > I am sure that this has been discussed before, but I can't seem to find > any recent posts. (I am running PostgreSQL 8.2) > > I have always ran PostgreSQL on Linux in the past, but the company I am > currently working for uses Windows

Re: [PERFORM] Performance of PostgreSQL on Windows vs Linux

2007-01-04 Thread Jeremy Haile
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

Re: [PERFORM] Performance of PostgreSQL on Windows vs Linux

2007-01-04 Thread Tom Lane
"Jeremy Haile" <[EMAIL PROTECTED]> 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

Re: [PERFORM] Performance of PostgreSQL on Windows vs Linux

2007-01-04 Thread Jeremy Haile
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 diffe

Re: [PERFORM] Performance of PostgreSQL on Windows vs Linux

2007-01-04 Thread Jeremy Haile
Thanks for the recommendations. I wasn't familiar with those packages! On Thu, 4 Jan 2007 00:46:32 +0100, "Dimitri Fontaine" <[EMAIL PROTECTED]> said: > Le jeudi 4 janvier 2007 00:18, Magnus Hagander a écrit : > > But to get a good answer on if the difference is > > significant enough to matter,

Re: [PERFORM] Performance of PostgreSQL on Windows vs Linux

2007-01-03 Thread Dimitri Fontaine
Le jeudi 4 janvier 2007 00:18, Magnus Hagander a écrit : > 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* workload,

Re: [PERFORM] Performance of PostgreSQL on Windows vs Linux

2007-01-03 Thread Magnus Hagander
Jeremy Haile wrote: > I am sure that this has been discussed before, but I can't seem to find > any recent posts. (I am running PostgreSQL 8.2) > > I have always ran PostgreSQL on Linux in the past, but the company I am > currently working for uses Windows on all of their servers. I don't > have

[PERFORM] Performance of PostgreSQL on Windows vs Linux

2007-01-03 Thread Jeremy Haile
I am sure that this has been discussed before, but I can't seem to find any recent posts. (I am running PostgreSQL 8.2) I have always ran PostgreSQL on Linux in the past, but the company I am currently working for uses Windows on all of their servers. I don't have the luxury right now of running