postgres is sane and consistent. Some things could seem weird, but those usually track to SQL standards, which are weird and dated, but at least consistency is still there. On the other hand, I never can be sure where mysql/mariadb decided to improve my life.

Oh believe me, I dislike mariadb for other reasons, like the fact that it sucks at picking indexes for queries.