When I was a bit younger I worked on quite some high profile (for my country) web apps. Think e-commerce, travel. Couple million users. We used Oracle on big fat metal server stacks for this.

I honestly thought this was needed because RAC and some other stuff. Uptime!

Now, a little older and wiser, I know all of these projects would have been fine on Postgres on some hosted provider.