HighGo Software Canada (a subsidiary of HighGo Software Inc.) is pleased to release HighGo Postgres Server 2.1 General Availability (HG-PGSQL 2.1 GA) on its website https://www.highgo.ca/products/highgo-postgresql-server/2-1-2/.
The GA release contains everything that was released with HG-PGSQL 2.0 beta few weeks earlier with the addition of some important bug fixes and updates to user documentation.
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.
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. We have also released quarterly updates for 1.0 release that contained the changes from the respective upstream PostgreSQL release. The latest release was HG-PGSQL 1.5 based on PG 12.5.
PostgreSQL is an advanced and powerful open source object relational database with over 30 years of active development. HG-PGSQL 2.1 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.1 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.
HG-PSQL 2.1 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.
“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.1.
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.1 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.1 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 etc.
Parallel Foreign Scan
HG-PGSQL 2.1 provides parallel scan of postgres FDW nodes, if a query fires several foreign scans they would be processed sequentially without this feature. The parallel foreign scan is also referred as async execution of FDW nodes, it enables the foreign scans to be executed in parallel on multiple foreign servers hence providing horizontal scalability and significant performance gains.
We also published a white-paper for parallel foreign scan feature containing the results of the benchmark of the feature. https://www.highgo.ca/wp-content/uploads/2020/12/HighGo_Parallel_Foreign_Scan_Whitepaper.pdf
Better Administration
Managing orphaned prepared transaction has always been a pain, HG-PGSQL 2.1 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.
HighGo CA is committed to do its part for making PostgreSQL better, we have significantly increased out contributions to PG community with patch review, blog post about PG functionality, code patches etc. We will look forward to increasing our contribution further for PostgreSQL community in year 2021.
Ahsan Hadi is a VP of Development with HighGo Software Inc. Prior to coming to HighGo Software, Ahsan had worked at EnterpriseDB as a Senior Director of Product Development, Ahsan worked with EnterpriseDB for 15 years. The flagship product of EnterpriseDB is Postgres Plus Advanced server which is based on Open source PostgreSQL. Ahsan has vast experience with Postgres and has lead the development team at EnterpriseDB for building the core compatibility of adding Oracle compatible layer to EDB’s Postgres Plus Advanced Server. Ahsan has also spent number of years working with development team for adding Horizontal scalability and sharding to Postgres. Initially, he worked with postgres-xc which is multi-master sharded cluster and later worked on managing the development of adding horizontal scalability/sharding to Postgres. Ahsan has also worked a great deal with Postgres foreign data wrapper technology and worked on developing and maintaining FDW’s for several sql and nosql databases like MongoDB, Hadoop and MySQL.
Prior to EnterpriseDB, Ahsan worked for Fusion Technologies as a Senior Project Manager. Fusion Tech was a US based consultancy company, Ahsan lead the team that developed java based job factory responsible for placing items on shelfs at big stores like Walmart. Prior to Fusion technologies, Ahsan worked at British Telecom as a Analyst/Programmer and developed web based database application for network fault monitoring.
Ahsan joined HighGo Software Inc (Canada) in April 2019 and is leading the development teams based in multiple Geo’s, the primary responsibility is community based Postgres development and also developing HighGo Postgres server.