Why favor PostgreSQL over MariaDB/MySQL?

Re:Why favor PostgreSQL over MariaDB/MySQL? by otterley on Wednesday September 06, 2017 @01:53AM (#15181521)

> If you really want no-ops deployment, use something that requires minimal amount of ops, like ElasticSearch. Just give it an obscene amount of RAM and it'll work fine for ages.

I can assure you this is not the case if your indexes are very large and their number is constantly growing, and/or clients are doing very complex queries that stress the system.

[ Parent | on HN ]

Re:Why favor PostgreSQL over MariaDB/MySQL? by pas on Thursday September 07, 2017 @04:48PM (#15195570)

The same thing applies to anything really, if you try to "shard" (partition, or simply do multi tenancy) based on files, MySQL tables, MongoDB collections, and of course elasticsearch indexes.

And you have to plan ahead and start with a large number of shards, to be able to scale your ES cluster.

Yet it's much better than trying to get some kind of SQL based cluster going, because those require knowledge of a lot of subtle internal details.

[ Parent | on HN ]