From: Josh Berkus <josh@agliodbs.com>
To: Clayton C. <clayton@marketingchallenge.com>
To: sqllist <pgsql-sql@postgresql.org>
Subject: Re: benchmarks
Date: Fri, 27 Oct 2000 23:24:51 -0700
Message-ID: <39FA7133.AEEE0D40@agliodbs.com> (raw)
References: <200010271836.e9RIaNZ96055@hub.org>
Frankyl, Clayton:
Comparing PostgreSQL to MySQL is like comparing an 18-wheel Kenworth
to a Porsche. The two are not equivalent ... if you want a simple, very
very fast READ-ONLY database, use MySQL. If you want a full-featured
transaction-environment database for a huge, complex set of data, use
PostgreSQL.
Any benchmarks you find are likely comapring the two for hosting web
sites, which is unfair to PostgreSQL. If everything your database needs
to do is serve up page content, go for MySQL. If you've got to build a
60-user inventory management system, MySQL won't even bring you close -
heck, it's not even close to SQL92-compliant.
Oracle is another game altogether, though I can imagine Postgres
catching up in a few years. Still, the price tag for Oracle weeds out
all but the very serious and deep-pocketed. And stay away from MS SQL
Server ... I run two of the damn machines, and they're nothing but
grief.
-Josh
--
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 436-9166
for law firms, small businesses fax 436-0137
and non-profit organizations. pager 338-4078
San Francisco
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com, clayton@marketingchallenge.com
Subject: Re: benchmarks
In-Reply-To: <39FA7133.AEEE0D40@agliodbs.com>
References: <200010271836.e9RIaNZ96055@hub.org> <39FA7133.AEEE0D40@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox