Postgresql vs MySQL

[Belisarius]

I've only used Postgresql, and was wondering what people thought of the various pros/cons of each?

[sde]

i think pgsql supports cell level locking whereas mysql only supports row level locking.

besides that, i don't know other differences.

[sdeming]

1 - MySQL is significantly faster in the early stages, but PostgreSQL scales better.
2 - Until recently, only PostgreSQL supported foreign keys. With MySQL 4.0 and InnoDB that isn't the case any longer.
3 - PgSQL is an object/relational database whereas MySQL is simply a relational database. Likely means nothing to most people.

A really good article that compares the two from a real world perspective: http://www.webtechniques.com/archives/2001/09/jepson/

[safecracker]

also take a look at this page, It should help you a lil postgres vs mysql

[bdl]

Thanks sdeming and safecracker for the links - good reads.