December 2021
Release Notes
HighGo Software is pleased to announce HighGo Postgres Server 3.1 General Availability (HG-PGSQL 3.1 GA). The GA release contains everything that was released with HG-PGSQL 2.x earlier with the addition of some important bug fixes and updates to user documentation. The HG-PGSQL 3.1 update contains all the changes included in PostgreSQL community release version 14.1 plus additional useful features unique to HG-PGSQL. Refer to the “Update Highlight “section for additional details.
With this release, HighGo Software continues to innovate and build on top of open source based database solution (PostgreSQL 14.1) which aims to deliver a solution with high performance, reliability and ease of use for small, medium and large-scale enterprises.
This is the third major release of HG-PGSQL and is built on top of Open source PostgreSQL version 14, it contained additional unique features of Shard management, Parallel backup, enhanced partitioning syntax and Oracle compatible packages.
PostgreSQL is an advanced and powerful open source object relational database with over 30 years of active development. HG-PGSQL 3.1 is the third release of HighGo Postgres Server, which aims to provide additional functionality and value to its users. It is built on top of an already robust, reliable and performant open source PostgreSQL 14.1 base.
Product Highlights
HG-PSQL 3.1 is built on top of PostgreSQL 14.1, PG 14 includes significant improvements to its indexing and lookup system that benefit large databases, including extended statistics collection, B-tree index improvements, datatypes subscripting and faster response times for queries that use aggregates or partitions, better query planning when using enhanced statistics, and more.
Along with highly requested features like parallelized vacuuming and incremental sorting, PostgreSQL 14 provides a better data management experience for big and small workloads, with optimizations for daily administration, more conveniences for application developers, and security enhancements.
“The innovations that each release brings along with its reputation for reliability and stability is the reason why more people choose to use PostgreSQL for their applications.”
Some of the highlighted features of HS-PGSQL that are molded in HG-PGSQL 3.1 to benefit from the performance and compatibility updates of PostgreSQL 14 include.
Global Transaction Management
HG-PGSQL provided a new syntax for creating partitioned tables that can span over one or more foreign servers i.e. Shards. It enabled the user to create a Sharded table where partitions live on external foreign servers. The latest version of the HG-PGSQL release provides the Global Transaction Management (GTM) capability that will enable the Sharded cluster to be used for OLTP write enabled workload. This guide will provide comprehensive details about the global transaction management feature that enables HG-PGSQL server to be used for Horizontality scalable OLTP workload.
Package Compatibility
HG-PGSQL enhances the database compatibility by providing package features to ease the complexities of migration to PostgreSQL from other DBMS systems. Package is a collection of PL objects, it is a schema object that contains a collection of related functionalities. Package contains procedure, functions, package level variables, cursors, type etc.
Plhgsql Enhancement
Ported following updates toward plhgsql language module from plpgsql.
- RETURN QUERY to execute its query using parallelism/
- Improve performance of repeated CALLs within plhgsql procedures.
Better Administration
Managing orphaned prepared transactions has always been a pain, HG-PGSQL provides administration features that will manage the orphan prepared transactions.
Refer to the following links for the official PostgreSQL 14.1 release notes:
PostgreSQL 14.1