PostgreSQL is the worlds’ best database
Postgres is my go-to RDBMS, but I do have one serious complaint: Connections are too expensive.<p>This is a side-effect of the old-school one-process-per-connection architecture that Postgres uses. MySQL (ick) easily handles thousands of connections on small servers; with Postgres you will need a <i>LOT</i> of RAM to sustain the same, RAM that would be better served as cache.<p>I&#x27;ve found (at least, for my current app) that the number of connections defines my scaling limit. I can&#x27;t add more appserver instances or their combined connection pools will overflow the limit. And that limit is disappointingly small. It&#x27;s not so painful that I want to reach for another RDBMS, but I&#x27;m bumping into this problem way too early in my scale curve.