Its not a meme. Postgres does all of those things good enough to be always considered the first pick.

I love Postgres. Im using it for majority of my career in IT. It never failed me, even on very big scale.

Amazing piece of software.