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 v

Re: [PERFORM] Postgres performance on Linux and Windows

2011-08-03 Thread Kevin Grittner
Dusan Misic 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 PostgreSQL. On both

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" wrote: > On 8/3/2011 11:37 AM, Dusan Misic wrote: >> I had done some testing for my application (WIP) and

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 having