Re: WHAT IS THE ADVANTAGE - Mailing list pgsql-admin

From William Yu
Subject Re: WHAT IS THE ADVANTAGE
Date
Msg-id bptcie$2rh8$1@news.hub.org
Whole thread Raw
In response to Re: WHAT IS THE ADVANTAGE  ("Ivan" <zenzo@net.hr>)
List 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.)


pgsql-admin by date:

Previous
From: "Armel HERVE"
Date:
Subject: Problem with pg_dump / pg_restore
Next
From: Rich Cullingford
Date:
Subject: Associating client PIDs with backend PIDs