RE: postgresql newsgroups

Поиск
Список
Период
Сортировка
От Nemeth Miklos
Тема RE: postgresql newsgroups
Дата
Msg-id 38ABBB03.5DFF4FD4@iqsoft.hu
обсуждение исходный текст
Ответ на postgresql newsgroups  (jamesbinary@icqmail.com (James))
Ответы Re: [GENERAL] RE: postgresql newsgroups
Re: [GENERAL] RE: postgresql and web transactions
Список 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

>
>




В списке pgsql-general по дате отправления:

Предыдущее
От: mr_hopkins@earthlink.net (Micheal H.)
Дата:
Сообщение: Re: postgresql newsgroups
Следующее
От: Nemeth Miklos
Дата:
Сообщение: Re: [GENERAL] splitting tables into db's