EnterpriseDB launched the latest version of its Postgres Plus Advanced Server database June 16 with an eye toward improving performance and scalability.
In Postgres Plus Advanced Server Version 8.3 Release 2, the company has added a feature called "infinite cache." Built on Memcached, the technology is designed to increase performance and scalability for read-mostly applications. With infinite cache, users can increase the amount of data maintained as in-memory cache by distributing the cache across existing inexpensive commodity hardware farms, the company said.
Compression of cache data allows the storing of entire databases in a durable fashion for fast performance, EnterpriseDB officials said, adding that storing more or all data in a RAM-based cache makes it so there are fewer disk operations. The technology is completely transparent to applications and requires no special caching code by application developers to safeguard any write operations, the officials said.
The company's newest release also includes Asynchronous Pre-Fetch, a high-performance query solution designed to optimize commodity RAID solutions. For security purposes, EnterpriseDB added support for LDAP and PAM (pluggable authentication module) authentication infrastructures, and a new feature called EnterpriseDB*Wrap protects stored procedures for secure distribution of proprietary or sensitive code.
Still, the company did not stray far from its traditional message regarding Oracle compatibility. Postgres Plus Advanced Server 8.3 R2 comes complete with several new features for deeper Oracle compatibility, including enhanced transaction control, support for advanced Oracle object types and packages, and tooling enhancements that facilitate the migration of Oracle schema and data to Postgres Plus Advanced Server, it said.
"All the new features and functionality in the latest version of Postgres Plus Advanced Server are inspired by customer input from organizations like Hi5 Networks and MyYearbook," Ed Boyajian, CEO of EnterpriseDB, said in a statement. "PostgreSQL users seeking an enterprise-class feature set and cutting-edge performance, as well as Oracle customers looking for low-cost, highly reliable RDBMS [relational DBMS] alternatives that require only minimal migration effort, should be considering Postgres Plus Advanced Server today."