3 ms·

> 2) MySQL is used and proven to scale on very large installments (Yahoo, Facebook, Google - just to name a few). Postgre's usage is much lower (Skype and Reddi

by russss 17y ago

> 2) MySQL is used and proven to scale on very large installments (Yahoo, Facebook, Google - just to name a few). Postgre's usage is much lower (Skype and Reddit from those I know of) We use Postgres (as well as MySQL) extensively at Last.fm, including on our terabyte+ main database handling many thousands of transactions per second. Except for the lack of decent replication, I have nothing bad to say about it. At a large scale, it's as easy as MySQL to tune (if not easier).

mahmud 17y ago
How do you overcome the lack of replication?
- russss 17y ago
  We use Slony to replicate read-only slaves for portions of our database (I wouldn't recommend it, Londiste is probably better), and Postgres warm standby for HA.