Re: Is PostGreSql's Data storage mechanism "inferior"? - Mailing list pgsql-general

From Greg Smith
Subject Re: Is PostGreSql's Data storage mechanism "inferior"?
Date
Msg-id Pine.GSO.4.64.0802011946420.22416@westnet.com
Whole thread Raw
In response to Is PostGreSql's Data storage mechanism "inferior"?  ("Swaminathan Saikumar" <swami@giveexam.com>)
List 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 by date:

Previous
From: "Vyacheslav Kalinin"
Date:
Subject: Re: problem with ORDER BY
Next
From: Greg Smith
Date:
Subject: Re: postgresql book - practical or something newer?