a while ago (too lazy to dig up the quote) the difference, or lack thereof, between postgreSQL and MySQL came up in a discussion between us, but at the time i didn't want to dig into it. now this post
on D* brought things back:
Podmins, which database are you running? Please answer the poll below.
PostgreSQL is faster than MariaDB / MySQL although it uses a bit more memory. The current diaspora* code base could be improved to reach better performance. Some queries could be optimized, but it's harder to do it with two database engines maintained at the same time. So I'm wondering what would be the impact on the community if diaspora* stops supporting MySQL. Of course, this would come with a detailed migration guide and plenty of time to upgrade, with full support of the community. Remember: this is just a poll to know your opinion, no decision has been taken at the moment.
i've seen claims like this, that pgsql is faster than mysql earlier, but never bothered to look into them more closely. this comparision seems to support the statement: https://stackshare.io/stackups/mariadb-vs-mysql-vs-postgresql
while this page says that, at least in their newest versions, both are pretty much the same in re. to features: http://blog.dumper.io/showdown-mysql-8-vs-postgresql-10/
personally this has not been a big issue for me since the sites i maintain are low-traffic and a few milliseconds won't make a difference. so far i always chose the path of least resistance,
i.e., go with the RDBMS an application supports out of the box. for #Hubzilla
that's MySQL, even though postgreSQL is supposed to work as well, but my first attempt with pgsql didn't work. with discourse
it's the other way around, and now i have both running on my VPS, which is not ideal.
more based on feeling than anything else i'd go with this guy's opinion: https://insights.dice.com/2015/03/19/why-i-choose-postgresql-over-mysqlmariadb/
and will try to set up Hz with postgres again.