It always worked well, but there are many newer developments around operations and scaling that finally made it much easier to run. Even now there are some limitations with logical replication and horizontal scaling but the main system can easily be installed and running in a few commands to serve most users just fine.

It should be noted that the rise of Docker containers and K8S has also helped greatly in letting users run all kinds of software with minimal work.