9.0 includes more major features than any release before it, including:
- Hot standby
- Streaming replication
- In-place upgrades
- 64-bit Windows builds
- Easy mass permissions management
- Anonymous blocks and named parameter calls for stored procedures
- New windowing functions and ordered aggregates
… and many more. For details on the over 200 additions and improvements in this version, developed by over a hundred contributors, please see the release notes.
These kinds of feature additions continue to make a strong case for why mission-critical technology tasks can continue to depend on the power, flexibility and robustness of PostgreSQL, said Afilias CTO Ram Mohan.