Re: [GENERAL] New FAQ item

On Fri, 9 Jul 1999, Bruce Momjian wrote:

> [SNIP]
>    Features
>           PostgreSQL has most features present in large commercial
>           DBMS's, like transactions, subselects, and sophisticated
>           locking. We have some features they don't have, like
>           user-defined types, inheritance, rules, and multi-version
>           concurrency control to reduce lock contention. We don't have
>           foreign key referential integrity or outer joins, but are
>           working on them for our next release.

actually, via refint, you do have foreign keys.

> [SNIP]
>           In comparison to MySQL or leaner database systems, we are
>           slower because we have transaction overhead. We are built for
>           flexibility and features, not speed, though we continue to
>           improve performance through profiling and source code analysis.

id rephrase this to include 'inserts/updates' -- 6.5 is comparable to
mysql for selects, given the proper indexes.

id also stress that postgres supports (fully?) SQL92, triggers,
transactions, subselects, views, etc; these features are currently
unimplemented in mysql and msql ( does anyone still _use_ msql?  3hours
for a 2 table join was just a big nono ).

or maybe instead of comparing to mysql/msql, compare pgsql to oracle,
sybase, informix, et al.  much cleaner comparison there, seeing
that mysql/msql dont support triggers, transactions, etc.

> [SNIP]

---
Howie <caffeine@toodarkpark.org>   URL: http://www.toodarkpark.org
"The distance between insanity and genius is measured only by success."