Personally, whenever I see a system like this I try to look for why they didn't go with an existing solution. And in 99% of cases either an existing solution never existed or they had a unique requirement that necessitated building something from scratch.
PostgreSQL is great for single instances but is poor when it comes to high availability and horizontal scalability.
Be curious what use cases where engineers are writing their own database but it is single instance.
There is plenty of absolute code abominations powering "world's largest applications"
Engineer competence is also vaguely related to quality of the infrastructure, yes, you need smart people to make big complex things, but you also need smart people to manage ungodly legacy enterprise spaghetti