HighGo PostgreSQL Server 1.1

Enterprise PostgreSQL Solutions

December 2019

Release Notes

HighGo Software Inc is pleased to announce the HighGo Postgres Server 1.1, it is built on top of PostgreSQL server 12.1. PostgreSQL is most advanced and powerful open source object relational database with over 30 years of active development. HG-PGSQL 1.1 is the first release of HighGo Postgres Sever, it aims to provide additional functionality and value to its users, this is on top of already robust, reliable and performing open source PostgreSQL 12.1 base. The area of focus for the first release is backup performance, ease of use, partitioning enhancement and scalability.  The goal is continue to develop on a very strong based and provide tremendous value to our end-users in variety of areas.

PostgreSQL 12.1 comes with a number of excellent and exciting features, it continues to improve the existing partitioning functionality by adding fast partition pruning along with additional partitioning improvements. It also contains a number of general performance improvements, optimisations for b-tree and other indexes, automatic inlining of common table expression (CTE). There are number of new authentication features including (Encryption of TCP/IP connections when using GSSAPI authentication), support for SQL/JSON path language and number of other exciting features.

Feature Highlights

Partitioning Enhancement

HG-PGSQL v1.1 enhances the table partitioning syntax to allow specifying the parent table and partitions in the same SQL statement. This is an ease of use feature that will take away the hassle of creating partitions separately from the parent table. This allows the end-user to specify the partitions and sub-partitions using the native PostgreSQL syntax in the same statement as the parent table.

Shard Management

Provide the capability of creating a sharded table by specifying parent table and foreign partitions in the same statement. This feature adds the ability to push-down partitions to the foreign server as part of the horizontal scaling / sharding effort. The user can specify the partitions along with the foreign server (shards) and use the push-down clause to automatically create partitions on the foreign servers. This is an exciting feature that automates the creation of partitions on the shards. This capability is added to postgres_fdw in this release and it can be extended to other databases.

Parallel Backup

Greatly improve the performance of full base backup by adding parallelism to the backup operation. This feature adds parallelism to base backup by spawning a configurable number of parallel workers to perform the backup. This feature enables the user to use more system resources by spawning multiple workers to perform backup and greatly reduce to time required.

Refer to the installation and user guide for more information on the new features and how to install the software in your system.