HighGo CA has released an update for its supported database systems on all supported platforms.
HighGo Software Canada (a subsidiary of HighGo Software Inc) has released an update for HighGo Postgres Sever (HG-PGSQL 1.7) and HighGo Postgres Sever (HG-PGSQL 2.3). The HG-PGSQL 1.7 update contains all the changes included in PostgreSQL community release version 12.7 plus additional useful features unique to HG-PGSQL. Similarly the HG-PGSQL 2.3 contains all the changes included in PostgreSQL community release 13.3 plus additional useful features unique to HG-PGSQL. Refer to “Update Highlight “section for additional details.
HG-PGSQL 1.7 is built on top of already feature-rich and powerful open-source database solution (PostgreSQL 12.7). HG-PGSQL 2.3 is built on top of already feature-rich and powerful open-source database solution (PostgreSQL 13.3). HighGo software is continuing to work closely with the PostgreSQL community release timeline and enhancing the features unique to HG-PGSQL.
With the release of HG-PSQL 1.7 and HG-PGSQL 2.3, 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.4 & 13.3). Our goal is to deliver a solution with high performance, reliability, and ease of use for small, medium and large-scale enterprises.
This update is to notify you about the new software release of HG-PGSQL 1.7 and HG-PGSQL 2.3 which are based on PostgreSQL 12.7 and PostgreSQL 13.3 release respectively.
HG-PGSQL 1.7 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).
please refer to the link below for changes included in PostgreSQL 12.7 release. A dump/restore is not required if you are running HG-PGSQL 1.x.
In addition to changes from PostgreSQL 12.7 update, HG-PGSQL 1.7 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.
HG-PSQL 2.3 is built on top of PostgreSQL 13.3, 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.
Refer to the following links to learn more:
- Official PostgreSQL 13.3 Release Notes
- New Features Added to HG-PGSQL Release Version 2
- Major New Features in PostgreSQL 13
- Installation and Quick Start Guide
Installation and Documentation
Highgo Postgres Server v1.7 and v2.3 supports RPM installation on the following platforms :
- CentOS (x86_64) 6.x
- CentOS (x86_64) 7.x
- CentOS (x86_64) 8.x
You may perform a fresh installation of HG-PGSQL 1.7 and HG-PGSQL 2.3 or upgrade from previous HG-PGSQL versions. Refer to the official Installation and quick start guide that is available on HighGo Software website. Visit:
What this update is for
This update is for users who are already using or interested in HighGo Postgres (HG-PGSQL). We will be providing update for HG-PGSQL 1.x and HG-PGSQL 2.x release every quarter which will be in sync with community updates.
How to Get this update
This update is for users who are already 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 updates.
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.