Re: DBMS Engines and Performance

On Tue, 30 Jan 2007, Bill Moran wrote:

> Consider the source. If he chose to write for MySQL instead of PostgreSQL,
> he probably isn't up to speed on what's going on with PostgreSQL.

Bill,

It's 'they' rather than 'he,' but your point is still valid.

> PostgreSQL is anything but behind on both performance and features.

This is what I thought. Thank you for confirming.

> MySQL's features and performance have still not caught up with PostgreSQL.
> MySQL's ability to run benchmarks really fast has exceeded most other
> databases. Have a gander at the following link (for example):
> http://blog.page2rss.com/2007/01/postgresql-vs-mysql-performance.html

I read this a few weeks ago when someone posted the URL to the list. Every
installation and use is different enough from all the others to make
generalizations inappropriate.

Regardless, when anyone designs what is intended to be a broadly used
business application _I_ belive that it should be designed from the very
beginning to use any -- or most -- readily available database engines, if
such is needed in the application. Why cut yourself off from a large segment
of the market, even if the application is F/OSS? That just does not make
business sense. However, this seems to be what every CRM/SFA[1]
vendor/project team but one has choosen to do. The one exception uses
postgres, but they bundle their application with 8.0.something, and we'd
have to use both an earlier and different installation from what we already
have here. That doesn't make business sense, either.

> I could be wrong, but I expect that a long thread is inevitable.

I hope that you are wrong. Preaching to the choir here is not going to
make any difference to the folks who write these other applcations. So,
repeating all the 'mine's bigger than yours' arguments will not convince
anyone differently. :-)

Many thanks,

Rich

--
Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc. | Accelerator(TM)
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863