Re: [PERFORM] Postgres performance on Linux and Windows

2011-08-08 Thread Greg Smith
Dusan Misic wrote: I had done some testing for my application (WIP) and I had executed same SQL script and queries on real physical 64-bit Windows 7 and on virtualized 64-bit CentOS 6. Both database servers are tuned with real having 8 GB RAM and 4 cores, virtualized having 2 GB RAM and 2

Re: [PERFORM] Postgres performance on Linux and Windows

2011-08-03 Thread Andy Colson
On 8/3/2011 11:37 AM, Dusan Misic wrote: I had done some testing for my application (WIP) and I had executed same SQL script and queries on real physical 64-bit Windows 7 and on virtualized 64-bit CentOS 6. Both database servers are tuned with real having 8 GB RAM and 4 cores, virtualized

Re: [PERFORM] Postgres performance on Linux and Windows

2011-08-03 Thread Dusan Misic
Thank you Andy for your answer. That is exactly what I had expected, but it is better to consult with experts on this matter. Again, thank you. Dusan On Aug 3, 2011 7:05 PM, Andy Colson a...@squeakycode.net wrote: On 8/3/2011 11:37 AM, Dusan Misic wrote: I had done some testing for my

Re: [PERFORM] Postgres performance on Linux and Windows

2011-08-03 Thread Kevin Grittner
Dusan Misic promi...@gmail.com wrote: My question is simple. Does PostgreSQL perform better on Linux than on Windows and how much is it faster in your tests? We tested this quite a while back (on 8.0 and 8.1) with identical hardware and identical databases running in matching versions of