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 the luxury right now of running my own benchmarks on the two OSes, > but wanted to know if anyone else has done a performance comparison. Is > there any significant differences? That depends on your usage pattern. There are certainly cases where the Win32 version will be significantly slower. For example, if you open a lot of new connections, that is a lot more expensive on Windows since each connection needs to execute a new backend due to the lack of fork(). I don't think you'll find any case where the Windows version is faster than Linux ;-) 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. //Magnus
