EnterpriseDB Extends PostgreSQL for Itanium

Thursday Jun 30th 2011 by Sean Michael Kerner

Oracle may be abandoning Itanium, but that's just creating opportunity for others to step into the breach.

Enterprise giant Oracle (NASDAQ: ORCL) has been warning its users this year that it plans to abandon the Intel Itanium architecture that powers HP's (NYSE: HPQ) Unix operating system. While Oracle isn't interested in supporting Itanium, others are.

EnterpriseDB today announced Postgres Plus Advanced Server 9.0, which provides Oracle compatibility and now supportS HP-UX on Itanium.

The Postgres Plus Advanced Server 9.0 builds on EnterpriseDB's Postgres Plus Standard 9.0 server release which debuted in January. Sitting at the core of EnterpriseDB's offerings is the open source PostgreSQL 9 release that was released to the community in September 2010.

"With 9.0 you can run Postgres Plus Advanced Server on HP Itanium," Robin Schumacher, director of product strategy at EnterpriseDB, told InternetNews.com. "We've talked to a number of HP customers that were not happy that Oracle is forcing them to switch out and they're looking for a database alternative and we can now give them that."

In addition to the new HP-UX support, Schumacher noted that EnterpriseDB is also adding support for Microsoft SQL Server replication as well. The SQL Server support is limited to replication and is not a compatibility layer, as is the case with Postgres Plus Advanced Server's support for Oracle databases.

"What our tool does is it goes into the databases that the user identifies to be replicated and it creates code objects that are responsible for the actual replication," Schumacher, said. "So it's not the same as our Oracle compatibility, we're just basically going in and when data objects change, we replicate them over to our system."

Schumacher added that the system provides for scheduling configuration so users can determine how often data is replicated.

Overall the new Postgres Plus Advanced Server 9.0 release also includes additional performance enhancements over its predecessors. One such improvement comes from the new parallel data loader.

"We've had a high speed load for a while that has mirrored what Oracle does but it has never done parallel operations," Schumacher said. "By adding this we're seeing an 800 to 1,200 percent performance gain depending on how people slice and dice their data."

There are also new utilities to help admins troubleshoot system performance. Schumacher noted that there is now an Index Advisor that is a smart utility that will recommend if new indexes are required on the underlying tables to improve performance. The Index Advisor can also provide forecasts on what the actual improvement will be as well as giving the admin the code required to implement the new index.

Additionally there is a new Code Profiler in the 9.0 release.

"This is for developers that are writing large stored procedures or functions with thousands of lines of code to help understand performance issues," Schumacher said. "It profiles the code and identifies the bottlenecks inside the stored procedures and highlight where time is being spent."

Sean Michael Kerner is a senior editor at InternetNews.com the news service of Internet.com, the network for technology professionals.

Mobile Site | Full Site