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@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
