Interesting Aberdeen survey of Mysql, Postgresql and Berkeley DB.
Its available from Sleepy Cat
Points to take home.
1) Most of the users of Postgresql, MySQL, and Berkeley are very happy with their application
2) Most of them do relatively simple queries
3) They didn't mention MySQL MAX
Features missing in open source databases according to Aberdeen:
MySQL does not offer the following key features typically provided in enterprise
databases(according to Aberdeen):
• Incremental and online/parallel backup/restore
• Encryption (security)
• Bit-mapped indexing (for large data warehouses)
• Single GUI administrative interface
• Views
• Stored procedures and triggers
• Object (complex data) table or data-type support
Users interviewed indicate that MySQL is adequately robust in small and mediumsized
applications.
Features desired according to users:
Triggers
Improved Replication
PostgreSQL does not offer the following key features typically provided in enterprise
databases(according to Aberdeen):
• Incremental and parallel backup/restore
• Encryption (security)
• Deadlock detection
• Row-level locking (typically required by large packaged applications) —
although PostgreSQL does offer alternative sub-table locking schemes
• Bit-mapped indexing (for large data warehouses)
• A single GUI administrative interface
• View update/insert/delete
Features desired according to users:
Gui control centre
Improved Replication
Two-phase commit
I think I want to check out the newest version of berkeley after reading this article. I was pretty sure that
NETAPP offers incremental backup of Postgresql - but perhaps I'm wrong.