PostgreSQL versus Other RDBMSs

One of the first questions asked by new users to RDBMSs is, “Which one is best?” That question is nearly impossible to answer without a full understanding of the database’s required functionality.

Comparing databases is like comparing vehicles. Each type of vehicle is suited for a particular task; motorcycles would be preferable over pickup trucks in some situations and would be disastrous in others. Likewise, the required functionality of a RDBMS must be understood before the right fit can be established.

In lieu of trying to compare apples to oranges, the following sections will give a brief listing of the popular RDBMSs currently available and will list their strong and weak points as well as their typical uses. ...

Get PostgreSQL Essential Reference now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.