Comment Re:Stronger rival? (Score 1) 215
The real drawbacks of using PostgreSQL: your hosting may not support it, the application you want to use may only support MySQL.
In the olden days, MySQL was synonymous with using the MyISAM storage engine, which was not very reliable but was faster than the alternatives (the InnoDB storage engine for MySQL or PostgreSQL.
MySQL+MyISAM was also far easier to setup and configure than MySQL+InnoDB or PostgreSQL.
And the logic was that for most websites, speed was more important than reliability. There are, however, two problems with that logic.
Problem 1: Your website may not need full ACID compliance level reliability, but it needs some. It's mighty inconvenient when then system crashes and boots to a corrupted database. It's like when Windows used FAT32 instead of NTFS.
Problem 2: Nowadays, MyISAM is actually only good at simple, read only, workloads. Complicated queries or writes tend to bog it down. And even simple websites have growing amounts of both.
Nowadays, InnoDB has improved to the point it is, in general, faster than MyISAM while providing better reliability (and it's finally been made the default MySQL storage).
PostgreSQL also improved a lot in performance. In particular, it tends to be better at handling complicated queries and at scaling better in multi-CPU systems.