You get the feeling that Postgres needs some marketing. It's a great piece of software but if people can't easily find out if it's been used at massive scale they aren't going to trust it.

Like it or not most deployments of MySQL are probably because people can easily hear about it being used for massive databases. The decision isn't based on technical merits (or lack of).