Re: Is PostGreSql's Data storage mechanism "inferior"?

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: Is PostGreSql's Data storage mechanism "inferior"?
Дата
Msg-id Pine.GSO.4.64.0802011946420.22416@westnet.com
обсуждение исходный текст
Ответ на Is PostGreSql's Data storage mechanism "inferior"?  ("Swaminathan Saikumar" <swami@giveexam.com>)
Список pgsql-general
On Wed, 30 Jan 2008, Swaminathan Saikumar wrote:

> * Performance considerations: Inserts and Updates into the PostgreSql
> database is much slower compared to MySql. PostgreSql hosting thus might
> slow down the display of the web page online.
> * Availability of inferior Data Storage mechanism: PostgreSql uses Postgres
> storage system, which is not considered to be transaction sae during
> PostgreSql hosting.

As many others have already pointed out that entire site is full of
incorrect information.  There are some potential performance issues on
insert/update in PostgreSQL because the default (and only recommended)
configuration makes sure that new transactions are committed to disk
properly when they end.  This can limit an individual client from being
able to make more than 100 commits/second on typical PC hardware.  But any
other database that is configured for a similar level of robustness has
the same problem.

You can find a more useful comparison of PostgreSQL and MySQL at
http://www.postgresql.org/docs/techdocs.83

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

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

Предыдущее
От: "Vyacheslav Kalinin"
Дата:
Сообщение: Re: problem with ORDER BY
Следующее
От: Greg Smith
Дата:
Сообщение: Re: postgresql book - practical or something newer?