Your Daily Source for Apache News and Information  
Breaking News Preferences Contribute Triggers Link Us Search About
Apache Today [Your Apache News Source] To internet.com

Apache HTTPD Links
The Apache Software Foundation
Apache XML Project
Apache-Perl Integration Project
Apache Module Registry
The Jakarta Project
ApacheCon
The Java Apache Project
PHP Server Side Scripting
Apache Project
Apache-Related Projects
The Apache FAQ
The Linux Channel at internet.com
PHPBuilder
Linux Apps
BSD Today
Linux Central
Just Linux
Linux Start
Apache Today
Linux Today
BSD Central
All Linux Devices
Linux Programming
Linux Planet
Linuxnewbie.org
Enterprise Linux Today
SITE DESCRIPTIONS
PR: Postgres Routs Competition in New Benchmark Tests
Aug 14, 2000, 15 :46 UTC (54 Talkback[s]) (57773 reads)

PRESS RELEASE: "NORFOLK, Va, August 14, 2000--PostgreSQL, a leading open source database, routed the competition in recent benchmark testing, topping the proprietary database leaders in industry-standard transaction-processing tests. PostgreSQL, also known as 'Postgres,' is an object-relational database management system (DBMS) that newly formed Great Bridge LLC will professionally market, service and support. Postgres also consistently outperformed open source competitors, including MySQL and Interbase, in the benchmark tests. Great Bridge will market Postgres-based open source solutions as a highly reliable and lower cost option for businesses seeking an alternative to proprietary databases."

"On the ANSI SQL Standard Scalable And Portable (AS3AP) benchmark, a rudimentary information retrieval test that measures raw speed and scalability, Postgres performed an average of four to five times faster than every other database tested, including two major proprietary DBMS packages, the MySQL open source database, and Interbase, a formerly proprietary product which was recently made open source by Inprise/Borland."

"In the Transaction Processing Council's TPC-C test, which simulates a real-world online transaction processing (OLTP) environment, Postgres consistently matched the performance of the two leading proprietary database applications. The two industry leaders cannot be mentioned by name because their restrictive licensing agreements prohibit anyone who buys their closed source products from publishing their company names in benchmark testing results without the companies' prior approval."

"'The test results show that Postgres is a robust, well-built product that must be considered in the same category as enterprise-level competition,' said Robert Gilbert, Great Bridge President and CEO. 'Look at the trendlines in the AS3AP test: Postgres, like the proprietary leaders, kept a relatively consistent output level all the way up to 100 concurrent users--and that output was four to five times faster than the proprietary products. Interbase and MySQL fell apart under heavy usage. That's a strong affirmation that Postgres today is a viable alternative to the market-leading proprietary databases in terms of performance and scalability--and the clear leader among open source databases.'"

"The tests were conducted by Xperts Inc. of Richmond, Virginia, an independent technology solutions company, using Quest Software's Benchmark Factory application. Both the AS3AP and the TPC-C benchmarks simulated transactions by one to 100 simultaneous users in a client-server environment. One hundred concurrent users approximates the middle range of a traditional database user pool; many applications never see more than a few users on the system at any given time, while other more sophisticated enterprise platforms number concurrent users in the thousands. In a Web-based application, where the connection to the database is measured in milliseconds, 100 simultaneous users would represent a substantial load--the equivalent of 100 customers hitting the "submit" button on an order form at exactly the same time."

"The AS3AP test measures raw database data retrieval power, showing an application's scalability, portability and ease of use and interpretation through the use of simple ANSI standard SQL queries. The TPC-C test simulates a warehouse distribution system, including order creation, customer payments, order status checking, delivery, and inventory management."

"'What stood out for us was the consistent performance of Postgres, which stayed the same or tested better than those of the leading proprietary applications. Postgres performed consistently whether it was being used by one or 100 people,' said Richard Brosnahan, senior software developer at Xperts."

"Postgres is a standards-based object-relational SQL database designed for e-business and enterprise applications. The software is open source and freely owned, continuously augmented by a global collaborative community of elite programmers who volunteer their time and expertise to improve the product. In the last two years, with the introduction of versions 6.5 and 7.0 of the software, Postgres has seen rapid enhancement through a series of high-level refinements."

"'Postgres' performance is a powerful affirmation of the open source method of development,' said Gilbert of Great Bridge. 'Hundreds, even thousands, of open source developers work on this software, demonstrating a rate of innovation and improvement that the proprietary competition simply can't match. And it's only going to get better.'" "Xperts ran the benchmark tests on Compaq Proliant ML350 servers with 512 mb of RAM and two 18.2 Gb hard disks, equipped with Intel Pentium III processors and Red Hat Linux 6.1 and Windows NT operating systems. The company ensured the tests' consistency by using the same computers for each test, with each product connecting to the tests through its own preferred ODBC driver. While Benchmark Factory does provide native drivers for some commercial databases, using each product's own ODBC ensured the most valid 'apples to apples' comparison."

"In the AS3AP tests, PostgreSQL 7.0 significantly outperformed both the leading commercial and open source applications in speed and scalability. In the tested configuration, Postgres peaked at 1127.8 transactions per second with five users, and still processed at a steady rate of 1070.4 with 100 users. The proprietary leader also performed consistently, with a high of 314.15 transactions per second with eight users, which fell slightly to 288.37 transactions per second with 100 users. The other leading proprietary database also demonstrated consistency, running at 200.21 transactions per second with six users and 197.4 with 100."

"The other databases tested against the AS3AP benchmarks, open source competitors MySQL 3.22 and Interbase 6.0, demonstrated some speed with a low number of users but a distinct lack of scalability. MySQL reached a peak of 803.48 with two users, but its performance fell precipitously under the stress of additional users to a rate of 117.87 transactions per second with 100 users. Similarly, Interbase reached 424 transactions per second with four users, but its performance declined steadily with additional users, dropping off to 146.86 transactions per second with 100 users."

"'It's just astounding, and unexpected,' said Xperts' Brosnahan of Postgres' performance. 'I ran the test twice to make sure it was running right. Postgres is just a really powerful database.'"

"In the TPC-C tests, Postgres performed neck and neck with the two leading proprietary databases. The test simultaneously runs five different types of simulated transactions; the attached graph of test results shows steadily ascending intertwined lines representing all three databases, suggesting the applications scaled at comparable rates. With all five transactions running with 100 users, the three databases performed at a rate of slightly above five transactions per second."

"'The TPC-C is a challenging test with five transactions running at once while querying against the database and the stress of a growing number of users. It showed that all the databases we tested handle higher loads very well, the way they should," Brosnahan explained.'"

"Neither Interbase nor MySQL could be tested for TPC-C benchmarks. MySQL could not run the test because the application is not adequately compliant with minimal ANSI SQL standards set in 1992. Interbase 6.0, recently released as open source, does not have a stable ODBC driver yet; while Xperts was able to adapt the version 5 ODBC driver for the AS3AP tests, the TPC-C test would not run. 'With MySQL it's an inherent design issue. Interbase 6 should run the TPC-C test, and perhaps would with tweaking of the test's code,' said Brosnahan."

"Great Bridge's Gilbert attributes Postgres' high performance to a quality differential that comes from the open source development process; the source code for Postgres has been subjected to years of rigorous peer review by some of the best programmers in the world, many of whom use the product in their work environments. "Great Bridge believes that Postgres is by far the most robust open source database available. These tests provide strong affirmation of that belief," he said. The company intends to work with hardware vendors and other interested parties to continue larger-scale testing of Postgres and other leading open source technologies."

"Great Bridge LLC provides open source solutions powered by PostgreSQL, the world's most advanced open source database. Great Bridge delivers value-added open source software and support services based on PostgreSQL, empowering e-business builders with an enterprise-class database and tools at a fraction of the cost of closed, proprietary alternatives."

"Headquartered in Norfolk, Virginia, Great Bridge is a privately held company funded by Landmark Communications, Inc., the media company that also owns The Weather Channel, weather.com, and national and international interests in newspapers, broadcasting, electronic publishing, and interactive media."

  Current Newswire:
Apache Jakarta James Mailserver v2.0a2 Released

PostgreSQL v7.2 Final Release

Daemon News: Multiple webservers behind one IP address

Zend Technologies launches Zend Studio 2.0

NuSphere first to enable development of PHP web services

Covalent Technologies raises $18 million in venture capital

Apache 1.3.23 released

wdvl: Build Your Own Database Driven Website Using PHP and MySQL: Part 4

Business 2.0: Find High Tech in the Bargain Basement

Another mod_xslt added to the Apache Module Registry database

 Talkback(s) Name  Date
HA HA! Nobody ever believes me when I tell them exactlywhat this aritcle states. ...   I told you so...   
  Aug 14, 2000, 21:46:15
Postgres is a good ORDBMS. Many people already knew this. Obviously, some people ...   The value of benchmarks...   
  Aug 14, 2000, 21:47:56
Okay, there's only one way to say this, in the words of that immortal Wendy& ...   Errr...   
  Aug 14, 2000, 21:51:11
What this press release says is that Postgres has a solid ODBC driver. ...   ODBC   
  Aug 14, 2000, 22:09:08
Probably the most provocative remark in the story was: "The two industry leader ...   Postgres Testing   
  Aug 14, 2000, 22:13:25
This article is all snake oil. I'm disappointed that I read the whole thing ...   Testing methodology   
  Aug 14, 2000, 22:22:16
Great to hear about postgresql. We are currently developing in a Linux/Apache/p ...   Your article   
  Aug 14, 2000, 22:30:34
So, who were these "leading proprietary databases"? FoxPro and MS Access? Sybase ...   So who were they?   
  Aug 14, 2000, 22:35:25
Which were the 2 commercial databases? ...   commercial db   
  Aug 14, 2000, 22:35:31
could these leading commercial applications be Oracle, Informix and MS SQL 7.0?? ...   leading commercial applications   
  Aug 14, 2000, 22:49:21
Very pretty. Work a bit more on the formatting and I'll give you a B+.One *m ...   Nice press release.   
  Aug 14, 2000, 23:08:35
ok nice to know ...   very interesting   
  Aug 14, 2000, 23:09:44
This sounds too much like the Microsoft/Mindcraft benchmarking we all know and l ...   Show us the actual benchmark...   
  Aug 14, 2000, 23:13:21
I don't find the results unbelievable but no data was provided to substantia ...   No Data?!?!   
  Aug 14, 2000, 23:18:23
The test simultaneously runs five different types of simulated transactions; the ...   Postgres Benchmark   
  Aug 14, 2000, 23:44:05
I notice that insert performance was not broken out. In informal tests here, Pos ...   Insert performance   
  Aug 15, 2000, 00:07:34
Ok, this is all just great and fine. Being a happy PostgreSQL-user this is good ...   More tests to confirm results   
  Aug 15, 2000, 01:36:18
At the risk of sounding redundant, I still have to say I'm shocked. Postgre ...   Where are the numbers?   
  Aug 15, 2000, 01:38:49
Whoopee, Benchmarketing has been opensourced too! ...   Benchmarketing Open Sourced!   
  Aug 15, 2000, 02:20:12
Well, I've never used MySQL and people always bothered me about it's "be ...   So, isn't it good?   
  Aug 15, 2000, 02:46:35
Is here. http://www.greatbridge.com/news/p_081420001.html ...   The actual press release with images..   
  Aug 15, 2000, 02:52:03
I use mySql because it is faster and easier to use than all the others. I run a ...   So...   
  Aug 15, 2000, 03:04:06
Yes Postgres is slower on inserts. It is because of the sanity checking it does ...   Re: Insert performance   
  Aug 15, 2000, 03:26:52
Interesting speculation. I was guessing that the 2 unmentionables were Oracle an ...   Re: Postgres Testing   
  Aug 15, 2000, 03:45:15
Yeah, that's great except for one thing. With Postgres, at least you can re ...   Re: Insert performance   
  Aug 15, 2000, 04:18:29
First off, kudos to the PostgreSQL development team for having come so far so fa ...   PostgreSQL, Interbase, MySQL   
  Aug 15, 2000, 04:33:21
These results are bogus. You have to follow the TPC's rules to have valid r ...   These results are bogus.   
  Aug 15, 2000, 05:07:37
This is just marketing hype. I may even agree with the conclusionsbut there is ...   No Names, No Data, No Information   
  Aug 15, 2000, 05:22:54
To article :"PR: Postgres Routs Competition in New Benchmark Tests "When is Post ...   Postgres is best of...?   
  Aug 15, 2000, 06:40:45
I must say that this is too thick, even humorous :) It's like one ofthose sa ...   Hype   
  Aug 15, 2000, 07:43:24
Remember that these tests benchmark the ODBC performance of the DBs.In most setu ...   Re: So...   
  Aug 15, 2000, 08:33:03
This is really a vague story. Why aren't the "2 commercial" DB's named i ...   No value   
  Aug 15, 2000, 10:22:00
Oracle and Sybase? ...   Re: Postgres Testing   
  Aug 15, 2000, 11:48:52
Does Postgres have JDBC drivers available ? ...   RE; JDBC Drivers ?   
  Aug 15, 2000, 14:18:24
Two things about the TPC-C strike me as fishy: 1) legally the TPC-C doesn't ...   TPC-C looks bogus   
  Aug 15, 2000, 14:27:00
 Interbase falls about after 100 users? Hmm... Tell that to the nearly 300 use ...   Ok, Sure... I Believe You!   
  Aug 15, 2000, 14:40:25
Hi everybody,I'm not a kind of "guru", but I think it's not good to star ...   Be calm   
  Aug 15, 2000, 14:54:33
www.tpc.org ...   Re: Errr...   
  Aug 15, 2000, 16:14:55
> Remember that these tests benchmark the ODBC performance of the DBs. In most s ...   Re: Re: So...   
  Aug 15, 2000, 16:58:34
Jasper wrote:This is really a vague story. Why aren't the '2 commercial& ...   Re: No value (or, Why don't they name names?)   
  Aug 15, 2000, 17:13:23
I use chat server (IP 166 MHZ / 64 RAM ) with MySQL. I have 10.000-30.000 query ...   sux   
  Aug 15, 2000, 19:46:47
After reading the various responses to this article, I have one question to all ...   What dont you get?   
  Aug 15, 2000, 20:30:52
I doubt anyone is saying MySQL is slow, it's just that PostgreSQL is faster. ...   Re: sux   
  Aug 15, 2000, 21:50:33
> Does Postgres have JDBC drivers available ?Yes, they come in the PostgreSQL so ...   Re: RE; JDBC Drivers ?   
  Aug 15, 2000, 21:55:36
Well, tentatively identified, at any rate. The version numbers contained in the ...   the databases identified   
  Aug 16, 2000, 10:03:55
The original article with graphs is at: http://www.greatbridge.com/news/p_081420 ...   And the commercial DBs are...   
  Aug 16, 2000, 14:50:46
I'm a web developper and I use database backends alot. For a mission critica ...   The Real World   
  Aug 16, 2000, 17:00:20
The "source" articles and explanations from the "benchmarking" company (somewhat ...   Don't you need a gigabit ethernet?   
  Aug 16, 2000, 20:19:36
> I'm a web developper and I use database backends alot. For a mission criti ...   Re: The Real World   
  Aug 17, 2000, 17:17:25
Well, they can't say. But anyone who knows what databases are out there, OR ...   Re: Errr...   
  Aug 31, 2000, 15:12:20
The membership of the TPC organization suggests that it would not be completely ...   Re: These results are bogus.   
  Sep 2, 2000, 02:14:27
The things are getting better....My company is developing a telemarketing softwa ...   Great!!!   
  Sep 12, 2000, 12:28:07
Think that the tests are comparing things that are not relevant in many cases. A ...   Interbase   
  Oct 21, 2000, 13:20:04
Nice link, but it doesn't go anywhere. :( ...   Re: The actual press release with images..   
  Aug 10, 2001, 05:44:15
Enter your comments below.
Your Name: Your Email Address:


Subject: CC: [will also send this talkback to an E-Mail address]
Comments:

See our talkback-policy for or guidelines on talkback content.

About Triggers Media Kit Security Triggers Login


All times are recorded in UTC.
Linux is a trademark of Linus Torvalds.
Powered by Linux 2.4, Apache 1.3, and PHP 4
Copyright 2002 INT Media Group, Incorporated All Rights Reserved.
Legal Notices,  Licensing, Reprints, & Permissions,  Privacy Policy.
http://www.internet.com/