Today, we are announcing the general availability of EDB Postgres Platform 12. This release includes all of the updates in open source PostgreSQL 12 AND new customer-requested features added to EDB Postgres.
Every year, the PostgreSQL community publishes one major release. We endeavor to upgrade our platform to support new open source features within a six to eight-week window after the community release. This is a major engineering effort, and we’re proud to have achieved our goal of updating the EDB Postgres Platform, yet again. This gives our customers access to the latest PostgreSQL features.
What’s in EDB Postgres Platform 12?
Improvements to the EDB Postgres Platform include:
EDB Postgres Advanced Server is our flagship product, an enhanced version of PostgreSQL that adds enterprise security, performance diagnostics, Oracle database compatibility and productivity features for developers and DBAs. New features include automatic interval partitioning, compound triggers, statistical functions, and user views. Partitions can automatically be created based on a time interval or a numeric sequence. This is a great way to quickly access historical data such as monthly records. Compound triggers reduce manual work and increase productivity by executing DML actions before/after the statement and before/after a table row. New functions (MEDIAN, LISTAGG) calculate medians and concatenate values; system views help DBAs identify user privileges and dependencies.
EDB Postgres Enterprise Manager (PEM) is a GUI-based management tool that combines monitoring, alerting and tuning of multiple open source PostgreSQL and/or EDB Postgres Advanced Server clusters. The new job scheduler allows DBAs to automate repetitive/routine tasks with support for exception/blackout timeframes along with alert emails when a job completes. The new “Explain” tab in the PEM Query Tool allows DBAs and developers to get insight into slow-performing queries by visually identifying the problem.
EDB Backup and Recovery Tool is our disaster recovery solution. Database backups can now be performed with the click of a button using the EDB Postgres Enterprise Manager GUI. Integration with PEM also means that Sysadmins and DBAs have visibility into all backups across their Postgres estate. Administrators no longer need to manage backups by logging into each EDB Backup and Restore Tool server individually but can manage a catalog of backups from one central console (see screenshot below).
More and more customers want to run Postgres on a hosted Kubernetes platform or on popular Kubernetes distributions like Red Hat OpenShift. Our solution for this deployment option is EDB Postgres on Kubernetes, a cloud-native Postgres solution with all the functionality needed for high availability and disaster recovery packaged into Docker containers. We recently introduced EDB Postgres Kubernetes Operator, to simplify deployment, monitoring, scaling up/down, recovery and upgrading Postgres. Now, EDB Postgres on Kubernetes supports all the functionality in EDB Postgres Platform 12.
These are just a handful of the enhancements added to EDB Postgres 12. Please refer to technical documentation on the respective products for details. If that is not enough for you to consider upgrading, open source PostgreSQL 12 offers significant improvements to query performance through better partitioning; provides application developers with new capabilities, such as SQL/JSON path expression support; optimizations for how common table expression (WITH) queries are executed and generated columns.
If you are a customer, we encourage you to download and upgrade now. If you are not a customer, we encourage you to try our software by following the same link.
Bhavani Rao is a Senior Product Marketing Manager for EnterpriseDB, responsible for product messaging and positioning. He has a diverse background, working with customers in DevOps, CI/CD, and Big Data. A recent convert to PostgreSQL, Bhavani is passionate about technology and how it can be leveraged to solve customer problems.