The program implements the SQL standard very well.
It includes support for "advanced" SQL stuff like window functions or common table expressions.
It supports lots of advanced data types, such as (multi-dimensional) arrays, user-defined types, etc.
It supports all sorts of performance optimization.
Popularity is far behind other Database platforms, thus it's harder to get community support or to google for results.
Replication is not yet well implemented.