Top 5 Reasons People Dismiss PostgreSQL

Jane Walker writes "In an effort to dispel some of the FUD surrounding this impressive product, this article puts forth several of the most commonplace reasons for a user to dismiss PostgreSQL." From the article: "While PostgreSQL's adoption rate continues to accelerate, some folks wonder why that rate isn't even steeper given its impressive array of features. One can speculate that many of the reasons for not considering its adoption tend to be based on either outdated or misinformed sources."

Comments

MySQL as a "small" database

[WebCowboy]

But on "small", I think you are unfair.

I concede that MySQL is very good at querying massively large tables of information, and as you point out its weakness is in referential integrity and data validation. Also, MySQL is not good with databases that are very dynamic--it is best that data be static (inserted once then selected ad-infinitum with few UPDATEs or DELETEs). Very excellent for most data logging or discussion forum websites, with few tables and simple relationships or none at all.

So to clarify, "small" refers to schema size and complexity, NOT the quantity of data within that schema.