- Flexible stored procedures and external functions
- WITH clauses
- Partitioning
- Large open-source extensions, modules and software helpers eco-system
The documentation is very well written and detailed, it helps to implement the right features for your needs in a timely manner.
Parallel processing of queries.
I've used it for 12 years.
There's been no issues deploying it.
The product always worked as described.
We've had no issues scaling it.
There is no tech support, however there is a lot of information available in forums or sites like serverfault.com.
I used MySQL. PostgreSQL syntax is much clearer and consistent, and its stored procedures are powerful and fast. The documentation is also much better and of more help.
On Debian, the provided packages are very easy to install and provide automatic updates. On Mac OS X, EnterpriseDB provides packages that work very well but as not as well integrated than in Debian.
I implemented in-house. PostgreSQL databases needs some maintenance but that can be easily automated by a skilled administrator.
PostgreSQL is free and open source.
Read the documentation.