| From: | Nemeth Miklos <nemeth(at)iqsoft(dot)hu> |
|---|---|
| To: | jamesbinary(at)icqmail(dot)com, pgsql <pgsql-general(at)hub(dot)org> |
| Subject: | RE: postgresql newsgroups |
| Date: | 2000-02-17 09:10:27 |
| Message-ID: | 38ABBB03.5DFF4FD4@iqsoft.hu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> And if this isn't too inflamatory a question, where does postgresql stand
> in comparison to MySql and DB2? (both of which aren't free I believe).
>
MySQL does NOT support transaction, which is indispensable for a real
DBMS used as the primary data storage system for reliable/consistent
business transactions.
However, MySQL is the fastest RDBMS ever seen, and perfect for data
warehouses and DSS and EIS purposes, as well as for
query databases for web sites.
DB2 does not support multiversion concurrency control, ie readers may be
blocked by writers.
DB2 does not support row level locking which is very important for
heavily concurrent databases.
PostgreSQL supports both transactions and row level locking. Only Oracle
may compete with PostgreSQL in this area.
NM
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Broytmann | 2000-02-17 10:17:27 | Re: [GENERAL] RE: postgresql newsgroups |
| Previous Message | Nemeth Miklos | 2000-02-17 08:52:47 | Re: [GENERAL] splitting tables into db's |