It's very easy to implement in your application as it supports most of the popular programming languages like Java/C#/.Net.It has excellent performance with large data sets compared to other databases out there.
The GUI tools are not so good for new users but if you have some experience then its worth using this product. I am currently working on an ecommerce website which uses postgresql backend dbms along side mysql databse.The major benefit i see here is that we can use both DBMS at same time without any issues or conflicts between them.We also get better scalability than single MySQL server setup.