Help | Site Map
Connecting Tech Pros Worldwide
 
 
LinkBack Thread Tools
  #1  
Old November 23rd, 2005, 12:24 AM
Anthony_Barker
Guest
 
Posts: n/a
Default 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/
  #2  
Old November 23rd, 2005, 12:28 AM
Frank Finner
Guest
 
Posts: n/a
Default Re: Whats missing from postgresql

On 31 Mar 2004 17:00:52 -0800 anthony_barker@hotmail.com (Anthony_Barker) sat down, thought long and
then wrote:
[color=blue]
> PostgreSQL does not offer the following key features typically
> provided in enterprise databases(according to Aberdeen):
> _ Incremental and parallel backup/restore[/color]

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.
[color=blue]
> _ 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[/color]

I would call PgAdmin such a thing.

[color=blue]
> _ 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/[/color]

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.

---------------------------(end of broadcast)---------------------------TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

 

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles