Elevate your technology and enterprise data strategy to Transform 2021.
Postgres Professional, a database provider based on a fork of the open-source Postgres relational database, today updated its offering to add support for storage-level compression and transaction IDs 64 bits, as well as all other functionality made available through the latest version of Postgres main database itself.
At the same time, Postgres Professional revealed that it was open source a multi-master cluster management tool that he previously developed because he continues to contribute to the community. This tool uses a Paxos consensus algorithm and two-phase commit protocol to determine a transaction outcome spanning disparately configured clusters.
Various Postgres forks are organized by several vendors. This approach allows the community to adopt multiple forks as a way to drive innovation, Postgres Professional CEO Oleg Bartunov told VentureBeat. “It’s a very liberal democratic community,” he said. Postgres Professional focuses specifically on creating extensions to the core open source database that enterprise IT organizations need, Bartunov added.
Postgres Pro Enterprise 13, for example, supports minor hot upgrades and makes it easier for enterprise IT organizations to update production systems without having to restart systems, Bartunov said. There is also now an incremental backup with consistency checks and a built-in task scheduler for delayed, scheduled, or asynchronous execution of offline tasks.
Machine learning algorithms are also used to optimize query planning, in addition to allowing the creation of over 10,000 partitions of a single database, also known as sharding.
Data compression at the database block level also serves to minimize the overall data footprint while increasing performance at a time when many organizations are using Postgres as an alternative to MySQL to drive digital transformation initiatives. business, said Bartunov. Postgres Professional also added support for a more transparent and manageable write-ahead (WAL) log that displays the size of the WAL generated by each server process.
Open source alternative
Postgres was originally developed to be an alternative to Oracle relational databases by providing an application programming interface that allows applications deployed on this commercial database to be transferred to an open source database. But after Oracle acquired the open source MySQL database, many other organizations started using Postgres to deploy applications.
As it continues to develop Postgres Pro Enterprise, the company will begin to focus on improving the cloud-native capabilities of the database, Bartunov said. That doesn’t mean the database will be redesigned as a set of microservices, but it will be enhanced to allow the platform to scale more dynamically, Bartunov said.
Many organizations have implemented an open source policy first as part of an effort to reduce software licensing costs. Developers also tend to prefer open source databases because they can start building an application without getting permission from a centralized IT team. In many cases, this application is initially little more than a pilot project that many centralized IT teams would not have the resources available to support.
The problem that IT teams inevitably face, however, is the cost of time and effort required to refactor an application developed on an open source database versus simply making the database adopted by the developer into a platform. more form to be supported alongside what has become a pantheon of other databases.
Each IT organization will of course have to decide for itself which Postgres database fork to use. Regardless of the instance, however, basic Postgres functionality is still generally available.
It’s all of these extra capabilities that enterprise IT organizations typically need that are difficult to implement whenever a vanilla distro of any open source project is used. This is why so many corporate IT teams still end up paying support fees for the privilege of using free software.
VentureBeat’s mission is to be a digital public place for technical decision-makers to learn about transformative technology and conduct transactions. Our site provides essential information on data technologies and strategies to guide you in managing your organizations. We invite you to become a member of our community, to access:
- up-to-date information on the topics that interest you
- our newsletters
- Closed thought leader content and discounted access to our popular events, such as Transform 2021: Learn more
- networking features, and more