HighGo PostgreSQL Server 1.9 (Nov 30, 2021)

Enterprise PostgreSQL Solutions

Release Notes

HighGo Software Canada (a subsidiary of HighGo Software Inc) is ready to release an update for HighGo Postgres Sever (HG-PSQL 1).  HG-PSQL 1.1 GA was released in December 2019, which included all the features and bug fixes from community PostgreSQL 12.1 release. We have been following the quarterly release schedule of PG 12.x and releasing an update for HG-PGSQL 1.x branch shortly after the community release, the last release was HG-PGSQL 1.8 based on PG 12.8 released in Sep 2021.

The PostgreSQL community has released an update for PG-12 (12.9), HG-PGSQL 1.9 will contain all the changes included in community 12.9 release in addition to the unique features added to HG-PGSQL release. Please refer to what’s new section for details.

With the release of HG-PSQL 1.9, HighGo Software is committed to delivering value to its end-users through innovation and building on top of open source based database solution (PostgreSQL 12.9).  Our goal is to deliver a solution with high performance, reliability and ease of use for small, medium and large-scale enterprises. 

What’s New

This update is to notify you about the new software release of HG-PSQL 1.9 which is based on PostgreSQL 12.9 release.

HG-PGSQL 1 is built on top of open source community release of PostgreSQL 12 which is packed with many exciting new features and improvements. Partitioning functionality has been improved by introducing fast partition pruning along with additional partitioning improvements. There have been several general performance improvements as well, such as optimizations for b-tree and other indexes as well as automatic inlining of common table expression (CTE).

The PostgreSQL community has recently released an update for PG-12 version, please refer to the link here for changes included in PostgreSQL 12.9 release. A dump/restore is not required if you are running HG-PGSQL 1.x.

In addition to changes from PostgreSQL 12.9 update, HG-PGSQL 1.9 contains the following unique features that were added to HG-PGSQL 1.0 release. There has been some enhancements and fixes for parallel backup feature in the previous point release of HG-PSQL 1.x.

  • Parallel Backup.                                                 
  • Partitioning Enhancements
  • Shard Management

Please refer to the user guide for detailed information on the HG-PGSQL’s unique features.

Who Is This For

This update is for the user who are using or interested in HighGo Postgres (HG-PGSQL). We will be providing update for HG-PGSQL 1 release every quarter which will be in sync with community update for PG-12.