What is it?
PostgreSQL is a relational database.
What can it do for me?
I use PostgreSQL in my current project. It stores trees with thousands of nodes and millions of objects that are assigned to these nodes. Each object contains large blobs of data. Recursive queries make working with trees very easy.