@stacksofplates said in Mastodon:

@scottalanmiller said in Mastodon:

@stacksofplates said in Mastodon:

Databases scale vertically. That means, it’s a lot easier and more cost efficient to buy a super beefy machine for your database, than it is to spread the database over multiple machines with sharding or replication.

Why Postgres? That seems like the least logical choice for this.

Not the least, it's better than something expensive or even MariaDB. It has great performance. If you never needed to scale, it might easily be best. But, as he's already found, he needs to scale.

Ya I guess I didn't mean least. It's obviously better than Oracle or Firebird. I just meant out of the plethora of options ( I was thinking Elasticsearch or Solr) this seemed like it wouldn't be considered.

Yeah... CouchDB, MongoDB, all kinds of things that seem like they'd be better for this.