RE: postgresql newsgroups

Поиск
Список
Период
Сортировка
Искать
От
Nemeth Miklos
Тема
RE: postgresql newsgroups
Дата
Msg-id
38ABBB03.5DFF4FD4@iqsoft.hu
Список
Дерево обсуждения
postgresql newsgroups jamesbinary@icqmail.com (James)
> 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

>
>



В списке pgsql-general по дате отправления
От: mr_hopkins@earthlink.net (Micheal H.)
Дата:
Сообщение: Re: postgresql newsgroups
От: Nemeth Miklos
Дата:
FAQ