Re: WHAT IS THE ADVANTAGE

From: William Yu <wyu(at)talisys(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: WHAT IS THE ADVANTAGE
Date: 2003-11-24 16:44:45
Message-ID: bptcie$2rh8$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ivan wrote:

> I use the MySQL database on the web for the forum and for a news system. I
> would like to know what are the advantages of pgsql over MySQL. I am
> entering in the world of databases so i don't know much as I am 16 years
> old.

For a forum & news system, there's probably zero difference/advantege.
:) Unless you get several million hits and tens of thousands of posts
every day. In that case, it would be an issue of whether MySQL InnoDB
row-locking would perform better or Postgresql's MVCC. (The default
MySQL ISAM tables would be cripped due to write-table-locking.)

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rich Cullingford 2003-11-24 16:55:07 Associating client PIDs with backend PIDs
Previous Message Anjan Dave 2003-11-24 16:42:01 Re: file too large, segmentation fault