Enterprisedb
A database that is suitable for enterprise applicdations must be highly scalable: Simply put, it needs to be really fast, both in high-volume transactional environments and when working with massive amounts of data.
EnterpriseDB is a combination of PostgreSQL - widely regarded as the open source database most suitable for on-line transaction processing (OLTP) – and significant enhancements that provide performance that is generally at least 50% faster than native PostgreSQL.
When EnterpriseDB is installed, it automatically optimizes itself for high-performance that competes with expensive commercial databases and far exceeds popular open source databases in typical transactional scenarios.
Best Open Source Foundation
PostgreSQL uses a multiple-row data storage strategy called MVCC (Multi-Version Concurrencey Control) to provide rapid responsiveness in high-volume environments. Oracle also uses this technology, for the same reason. Other technologies used by PostgreSQL to enhance its performance include shared row-level locking, an advanced technique that improves upon the row-level locking feature of other databases, specially tuned symmetric multiprocessor (SMP) performance, dynamic conversion of indices to bitmaps in memory, and table partitioning using constraint exclusion.
Scalability Enhancements
Using various techniques, including installation-specific dynamic optimization, EntepriseDB has iproved on the already-excellent scalability of PostgreSQL, so that it runs more than 50% faster in most circumstances.
EnterpriseDB also includes integrated database replication capabilities – based on the open source SLONY-I project – that provide workload distribution, enable failover protection and allow sophisticated reporting, decision support and remote access without compromising the performance of websites and other applications that exercise your primary database.
![]()
If you're interested in this topic, these articles may be helpful:
![]() | Implementing Scalable Atomic Locks for Multi-Core Intel® EM64T and IA32 Architectures by Michael Chynoweth and Mary R Lee Abstract There are several diffe... |
![]() | Solaris DTrace How To Guide Introduction to DTrace DTrace is a comprehensive dynamic traci... |
![]() | Download: Rational Data Architect Download a free trial version of IBM® Rational® Data Architect, an e... |
![]() | Reliable A database that is the trusted foundation of mission-critical applicat... |
![]() | Open Up Your Enterprise With almost 10 years of open source experience under my belt, I have... |
![]()
Related Jobs:


