On Mon, May 10, 2010 at 11:31 AM, Leland Jackson <lelandj12...@gmail.com> wrote: > Results of test performed between MSSQL and PostgreSQL: > > #------------------------------- > Excerpt: > > 5 Conclusions > This paper compares the performance and scaling of the BenchmarkSQL > workload running > on Red Hat Enterprise Linux 5.4 with that of the same workload on > Windows Server 2008 R2 > Enterprise. The database servers used were HP ProLiant DL370 G6 servers > equipped with > 48 GB of RAM and comprised of dual sockets, each with a 3.2 GHz Intel > Xeon W5580 > Nehalem processor (totaling 8 cores). > The data presented in this paper establishes that a common OLTP workload > on PostgreSQL > can contend with SQL Server and with minimal tuning, is capable of > outperforming SQL > Server using the same load in an enterprise environment. > The number of actual users and throughput supported in any specific > customer situation > would naturally depend on the specifics of the application used and the > degree of user > activity. > > http://pgsnake.blogspot.com/2010/05/postgres-vs-sql-server.html > > #----------------------------------
I know it's a paper done by RedHat so I would question the true configuration used for EACH db in the test. If both teams brought in their tuned beast it would be unbiased. Using JDBC for connections is probably the clear difference between the two camps but only M$ can say why. They looked pretty close in the cheezzzzeeeee graph presented as well as any real output from the performance software. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/aanlktim5urpizcsrad4ujpu5fgytg5j8itpgvq6gg...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
