Elevate your enterprise data technology and strategy at Transform 2021.


Postgres Professional, provider of a database based on a fork of the open source Postgres relational database, today updated its offering to add support for storage-level compression and 64-bit transaction identifiers, along with all the other capabilities made available via the latest release of the core Postgres database itself.

At the same time, Postgres Professional revealed it is open-sourcing a multi-master cluster management tool it previously developed as it continues to contribute to the community. That tool makes use of a Paxos consensus algorithm and two-phase commit protocol to determine a transaction outcome spanning disparately configured clusters.

Various forks of Postgres are being curated by multiple providers. This approach enables the community to embrace multiple forks as a way to spur innovation, Postgres Professional CEO Oleg Bartunov told VentureBeat. “It’s a very liberal democratic community,” he said. Postgres Professional is specifically focused on making extensions to the core open source database enterprise IT organizations require, Bartunov added.

Postgres Pro Enterprise 13, for example, provides support for hot minor upgrades that enables enterprise IT organizations to more easily update production systems without having to restart systems, noted Bartunov. There is also now an incremental backup with consistency checks and a built-in task scheduler for delayed, scheduled, or asynchronous execution of offline jobs.

Machine learning algorithms are also being employed to optimize query planning in addition to making it possible to create more than 10,000 partitions of a single database, otherwise known as sharding.

Data compression at the database block level also serves to minimize the overall data footprint while also increasing performance at a time when many organizations are employing Postgres as an alternative to MySQL to drive digital business transformation initiatives, said Bartunov. Postgres Professional has also added support for a more transparent and manageable Write-Ahead Log (WAL) that shows the size of WAL generated by each server process.

Postgres was originally developed to provide an alternative to Oracle relational databases by providing an application programming interface that enables applications deployed on that commercial database to be shifted over to an open source database. However, after Oracle acquired the open source MySQL database many more organizations started employ Postgres to deploy applications.

As Postgres Pro Enterprise continues to develop the company will next focus on improving the cloud-native capabilities of the database, said Bartunov. That doesn’t mean the database will be rearchitected into a set of microservices, but rather will be enhanced to enable the platform to scale up and down more dynamically, noted Bartunov.

Many organizations have an open source first policy in place as part of an effort to reduce software licensing costs. Developers also tend to prefer open source databases because they don’t need to receive permission from a centralized IT team before they start building an application. In many cases, that application initially is little more than a pilot project that many centralized IT teams would not have resources available to support.

The issue that IT teams inevitably face, however, is the cost of the time and effort required to refactor an application developed on an open source database versus just making the database adopted by the developer one more platform to support alongside what has become a pantheon of other databases.

Each IT organization will naturally have to decide for themselves what fork of Postgres database to employ. Regardless of the instance, however, the core Postgres capabilities are always generally available.

It’s all those extra capabilities that enterprise IT organizations typically require that are challenging to implement whenever a vanilla distribution of any open source project is employed that can be challenging, which, of course, is why so many enterprise IT teams still wind up paying a support fee for the privilege of using free software.

VentureBeat

VentureBeat’s mission is to be a digital town square for technical decision-makers to gain knowledge about transformative technology and transact. Our site delivers essential information on data technologies and strategies to guide you as you lead your organizations. We invite you to become a member of our community, to access:

  • up-to-date information on the subjects of interest to you
  • our newsletters
  • gated thought-leader content and discounted access to our prized events, such as Transform 2021: Learn More
  • networking features, and more

Become a member

Source

By admin