November 2020
Release Notes
HighGo Software Canada (a subsidiary of HighGo Software Inc.) is pleased to announce HighGo Postgres Server 2.0 beta (HG-PGSQL 2.0 beta). With this release, HighGo Software continues to innovate and build on top of open source based database solution (PostgreSQL 13.1) with aims to deliver a solution with high performance, reliability and ease of use for small, medium and large-scale enterprises. HG-PGSQL 2.0 will be in beta cycle for approximately a month, the GA will be released with fixes for any important issues that are uncovered during the beta testing period.
This is second major release of HG-PGSQL, the first major release HG-PSQL 1.0 was released in Dec 2019. HG-PSQL 1.0 was built on top of Open source PostgreSQL version 12, it contained additional unique features of Shard management, Parallel backup and enhanced partitioning syntax.
PostgreSQL is an advanced and powerful open source object relational database with over 30 years of active development. HG-PGSQL 2.0 beta is the second release of HighGo Postgres Sever, which aims to provide additional functionality and value to its users. It is built on top of already robust, reliable and performant open source PostgreSQL 13.1 base.
HG-PGSL 2.0 comes with additional functionality on top of the open source PostgreSQL database, which enables users to build a highly performant and scalable PostgreSQL database clusters with better database compatibility and administration. This simplifies the process of migration to PostgreSQL from other DBMS with enhanced database administration experiences.
Update Highlights
HG-PSQL 2.0 is built on top of PostgreSQL 13.1, PG 13 includes significant improvements to its indexing and lookup system that benefit large databases, including space savings and performance gains for indexes, 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 13 provides a better data management experience for big and small workloads, with optimizations for daily administration, more conveniences for application developers, and security enhancements.
“PostgreSQL 13 showcases the collaboration and dedication of our global community in furthering the abilities of the world’s most advanced open source relational database” said Peter Eisentraut, a PostgreSQL Core Team member.
“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.”
Refer to the following links for the official PostgreSQL 13.0 and 13.1 release notes:
PostgreSQL 13.0
PostgreSQL 13.1
In addition, HighGo Softwre further enhances the capability of PostgreSQL software by adding the following new features that are unique to HG-PGSQL 2.0.
Global Transaction Management
HG-PGSQL 1.0 provided a new syntax for creating partitioned tables that can span over one or more foreign server i.e. Shards. It enabled the user to create Sharded table where partitions live on external foreign servers. The latest version of HG-PGSQL 2.0 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 sever to be used for Horizontality scalable OLTP workload.
Simpler Workload Environments for Migration
HG-PGSQL 2.0 enhances the database compatibility by providing package features to ease the complexities of migration to PostgreSQL from other DBMS systems.
Better Administration
Managing orphaned prepared transaction has always been a pain, HG-PGSQL 2.0 provides administration feature that will manage the orphan prepared transactions.
Refer to the software user guide below for detailed information on how to utilize these features for different business needs.
Known Issues
Package related regression test failure
Cache lookup failure occurs when trying to access a package variable of a compiled package which was later dropped. The correct behavior is to throw a meaningful error message when some object tries to access an element of a dropped package. This is a negative scenario and it only fails on CentOS 7 platform.
Query hanging with global snapshots
When global snapshot parameter is enabled, a distributed query can end up hanging the server if one of the servers was shut down and prepared transaction is removed in an unresolved state. Issuing a global transaction after performing these activities results in an error. This is a corner scenario and will be fixed in GA release
Please refer to the installation and user guide for more information on the new features and how to install the software in your system.