Whats missing from postgresql

Aberdeen has a review of open source rdbms. The overall review was
quite positive but mentioned a few things missing.

Features desired according to users:
Gui control centre
Improved Replication
Two-phase commit

They list what they think is missing from postgresql compared with
Oracle/db2/MSSQL

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

I was pretty sure that NETAPP offers incremental backup of Postgresql
- but perhaps I'm wrong.

What about the row level locking or the other features. Are they
issues for anyone?

http://www.sleepycat.com/aberdeenwp/

Anthony
http://xminc.com/mt/

On 31 Mar 2004 17:00:52 -0800 anthony_barker(at)hotmail(dot)com (Anthony_Barker) sat down, thought long and
then wrote:

> PostgreSQL does not offer the following key features typically
> provided in enterprise databases(according to Aberdeen):
> _ Incremental and parallel backup/restore

If you do several backup jobs for several databases on one engine at the same time, isn´t that
"parallel backup"? But incremental would be really a nice thing for big databases.

> _ 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

I would call PgAdmin such a thing.

> _ View update/insert/delete
>
>
> I was pretty sure that NETAPP offers incremental backup of Postgresql
> - but perhaps I'm wrong.
>
> What about the row level locking or the other features. Are they
> issues for anyone?
>
> http://www.sleepycat.com/aberdeenwp/
>
> Anthony
> http://xminc.com/mt/

What I am still _really_ missing is a simple reliable way for replication. I really would appreciate
a good eager master-master-replication for failover purposes (eg. Heartbeat). Although once an
Oracle consultant told me, that even for Oracle it is not simple and they do not recommend it. They
prefer "lazy" replication.

Regards, Frank.