Sponsor of the Day:
Jerkmate
https://www.highgo.ca/tag/tcp/
TCP - Highgo Software Inc.
highgo software inctcp
https://www.highgo.ca/news/
News - Highgo Software Inc.
highgo software incnews
https://www.highgo.ca/tag/fdw/
fdw - Highgo Software Inc.
fdw highgo softwareinc
https://www.highgo.ca/2019/11/07/
November 7, 2019 - Highgo Software Inc.
2019 highgo softwarenovember 7inc
https://www.highgo.ca/tag/smgr/
smgr - Highgo Software Inc.
highgo software inc
https://www.highgo.ca/2024/08/
August, 2024 - Highgo Software Inc.
2024 highgo softwareaugustinc
https://www.highgo.ca/2024/02/23/
February 23, 2024 - Highgo Software Inc.
february 23 2024highgo software inc
https://www.highgo.ca/2020/01/10/
January 10, 2020 - Highgo Software Inc.
january 10 2020highgo software inc
https://www.highgo.ca/2022/02/
February, 2022 - Highgo Software Inc.
2022 highgo softwarefebruaryinc
https://www.highgo.ca/2021/09/10/hg-pgsql-1-8-and-hg-pgsql-2-4-released-sep-3-2021/
HG-PGSQL 1.8 and HG-PGSQL 2.4 Released (Sep 3, 2021)! - Highgo Software Inc.
Aug 3, 2023 - HighGo CA has released a routine update for its supported database systems on all supported platforms. HighGo Software Canada (a subsidiary of HighGo Software...
hg pgsql 12 4 released2021 highgo softwaresep 38
https://www.highgo.ca/2021/08/23/tuning-the-pgpool-ii-load-balancer/
Tuning the Pgpool-II Load balancer - Highgo Software Inc.
Aug 3, 2023 - Load balancing increases the system throughput from the application standpoint by distributing the read load from application to multiple replicated database...
load balancer highgopgpool iisoftware inctuning
https://www.highgo.ca/2021/12/
December, 2021 - Highgo Software Inc.
2021 highgo softwaredecemberinc
https://www.highgo.ca/2021/08/
August, 2021 - Highgo Software Inc.
2021 highgo softwareaugustinc
https://www.highgo.ca/2020/03/26/optimizing-sql-step-1-explain-in-postgresql-part-1/
Optimizing SQL – Step 1: EXPLAIN in PostgreSQL – Part 1 - Highgo Software Inc.
Aug 3, 2023 - This is my first blog in a series of SQL optimization blogs. So expect some basic information in here along with some nice insights. My aim is to help you walk...
highgo software incoptimizing sqlstep 1postgresql partexplain
https://www.highgo.ca/2022/05/06/atomic-commit-with-2-phase-commit-in-fdw-distributed-setup/
Atomic Commit with 2 Phase Commit in FDW Distributed Setup - Highgo Software Inc.
Aug 3, 2023 - 1. Introduction PostgreSQL's 2 phase commit (2PC) feature allows a database to store the details of a transaction on disk without committing it. This is done...
highgo software incatomic commit2 phasefdwdistributed
https://www.highgo.ca/2022/04/29/
April 29, 2022 - Highgo Software Inc.
2022 highgo softwareapril 29inc
https://www.highgo.ca/2024/05/17/
May 17, 2024 - Highgo Software Inc.
may 17 2024highgo software inc
https://www.highgo.ca/tag/window-function/
Window Function - Highgo Software Inc.
highgo software incwindowfunction
https://www.highgo.ca/category/jit/
JIT - Highgo Software Inc.
highgo software incjit
https://www.highgo.ca/2022/01/19/2021-pg-asia-conference-delivered-another-successful-online-conference-again/
2021 PG Asia Conference Delivered Another Successful Online Conference Again! - Highgo Software Inc.
highgo software incasia conferenceanother successful2021pg
https://www.highgo.ca/2021/05/31/
May 31, 2021 - Highgo Software Inc.
may 31 2021highgo software inc
https://www.highgo.ca/2023/06/23/setup-postgresql-development-environment-on-macos/
Setup PostgreSQL development environment on MacOS - Highgo Software Inc.
Aug 3, 2023 - 1. Overview When verifying PostgreSQL patches on MacOS, I couldn't find a straightforward blog to follow for setting up the environment quickly. This blog aims...
highgo software incpostgresql developmentsetupenvironmentmacos
https://www.highgo.ca/2021/08/06/understanding-the-security-around-postgresql/
Understanding the Security Around PostgreSQL - Highgo Software Inc.
Aug 3, 2023 - 1. What Is Security? The word “Security” is a very broad concept and could refer to completely different procedures and methodology to achieve. Knowing what...
postgresql highgo softwareunderstandingsecurityaroundinc
https://www.highgo.ca/2023/06/23/
June 23, 2023 - Highgo Software Inc.
june 23 2023highgo software inc
https://www.highgo.ca/category/kms/
KMS - Highgo Software Inc.
highgo software inckms
https://www.highgo.ca/tag/memory-cache/
memory cache - Highgo Software Inc.
highgo software incmemorycache
https://www.highgo.ca/2022/12/16/global-unique-index-attach-support-and-its-potential-deficiency/
Global Unique Index ATTACH Support and Its Potential Deficiency - Highgo Software Inc.
Aug 3, 2023 - 1.0 Introduction In my previous post here, I introduced the global unique index feature that my colleague, David, and I work together and explained how global...
highgo software incglobal uniqueindexattachsupport
https://www.highgo.ca/tag/sql/
sql - Highgo Software Inc.
highgo software incsql
https://www.highgo.ca/2024/04/
April, 2024 - Highgo Software Inc.
2024 highgo softwareaprilinc
https://www.highgo.ca/2021/01/08/
January 8, 2021 - Highgo Software Inc.
2021 highgo softwarejanuary 8inc
https://www.highgo.ca/2024/06/11/pgconf-dev-2024-shaping-the-future-of-postgresql-in-vancouver/
PGConf.dev 2024: Shaping the Future of PostgreSQL in Vancouver - Highgo Software Inc.
Jun 12, 2024 - Introduction For the first time ever, PGConf.dev (previously known as PGCon from 2007 to 2023) has taken place in the picturesque city of Vancouver, Canada....
highgo software incpgconf dev2024 shapingfuturepostgresql
https://www.highgo.ca/2020/10/
October, 2020 - Highgo Software Inc.
2020 highgo softwareoctoberinc
https://www.highgo.ca/2025/10/
October, 2025 - Highgo Software Inc.
2025 highgo softwareoctoberinc
https://www.highgo.ca/careers/
Careers - Highgo Software Inc.
Mar 12, 2024 - Current Openings Unfortunately, we currently do not have any career openings. Please check back again later!
highgo software inccareers
https://www.highgo.ca/2020/09/
September, 2020 - Highgo Software Inc.
2020 highgo softwareseptemberinc
https://www.highgo.ca/2024/02/09/
February 9, 2024 - Highgo Software Inc.
february 9 2024highgo software inc
https://www.highgo.ca/tag/logical-replication/
logical replication - Highgo Software Inc.
replication highgo softwarelogicalinc
https://www.highgo.ca/category/aes/
AES - Highgo Software Inc.
highgo software incaes
https://www.highgo.ca/2020/02/28/parallel-vacuum-in-upcoming-postgresql-13/
Parallel Vacuum in Upcoming PostgreSQL 13 - Highgo Software Inc.
Aug 3, 2023 - Any performance feature in PostgreSQL that mentions the “parallel” keyword excites me. So it was natural that parallel vacuum took my complete attention when...
postgresql 13 highgosoftware incparallelvacuumupcoming
https://www.highgo.ca/2023/06/06/
June 6, 2023 - Highgo Software Inc.
2023 highgo softwarejune 6inc
https://www.highgo.ca/2019/07/
July, 2019 - Highgo Software Inc.
2019 highgo softwarejulyinc
https://www.highgo.ca/2021/02/
February, 2021 - Highgo Software Inc.
2021 highgo softwarefebruaryinc
https://www.highgo.ca/2021/04/22/hash-index-internals/
Hash Index Internals - Highgo Software Inc.
Aug 3, 2023 - Indexes are key database server features that enhance its performance to retrieve data faster than a complete table scan (unless the index is vastly bloated)....
highgo software inchashindexinternals
https://www.highgo.ca/2021/11/
November, 2021 - Highgo Software Inc.
2021 highgo softwarenovemberinc
https://www.highgo.ca/2020/09/15/
September 15, 2020 - Highgo Software Inc.
september 15 2020highgo software inc
https://www.highgo.ca/tag/firewall/
firewall - Highgo Software Inc.
highgo software incfirewall
https://www.highgo.ca/2023/09/11/
September 11, 2023 - Highgo Software Inc.
september 11 2023highgo software inc
https://www.highgo.ca/2019/07/19/pgpool-ii-4-1-taking-the-bull-by-its-horn/
Pgpool II 4.1 taking the bull by its horn - Highgo Software Inc.
Aug 3, 2023 - I will start with providing some explanation for the blog title before i dive into the blog itself. The title of this blog is that
highgo software incpgpool ii4 1takingbull
https://www.highgo.ca/2020/08/08/partitioning-improvements-in-postgresql-13/
Partitioning Improvements in PostgreSQL 13 - Highgo Software Inc.
Aug 3, 2023 - The table partitioning feature in PostgreSQL has come a long way after the declarative partitioning syntax added to PostgreSQL 10. The partitioning feature in...
postgresql 13 highgosoftware incpartitioningimprovements
https://www.highgo.ca/2021/06/04/
June 4, 2021 - Highgo Software Inc.
2021 highgo softwarejune 4inc
https://www.highgo.ca/tag/compute/
compute - Highgo Software Inc.
highgo software inccompute
https://www.highgo.ca/2023/07/14/building-postgresql-in-a-modern-way-with-meson/
Building PostgreSQL in a Modern Way – With Meson - Highgo Software Inc.
Aug 3, 2023 - 1.0 Introduction Starting in PostgreSQL 16, we will have an option to build PostgreSQL software using a modern build system, meson, in addition to the...
highgo software incmodern waybuildingpostgresqlmeson
https://www.highgo.ca/2021/05/
May, 2021 - Highgo Software Inc.
2021 highgo softwaremayinc
https://www.highgo.ca/2020/03/12/
March 12, 2020 - Highgo Software Inc.
march 12 2020highgo software inc
https://www.highgo.ca/2020/01/22/understanding-security-features-in-postgresql-part-1/
Understanding Security Features in PostgreSQL – Part 1 - Highgo Software Inc.
Aug 3, 2023 - 1. Introduction PostgreSQL is packed with several security features for a database administrator to utilize according to his or her organizational security...
highgo software incunderstanding securitypart 1featurespostgresql
https://www.highgo.ca/2022/01/
January, 2022 - Highgo Software Inc.
2022 highgo softwarejanuaryinc
https://www.highgo.ca/2023/05/09/various-restoration-techniques-using-postgresql-point-in-time-recovery/
Various Restoration Techniques Using PostgreSQL Point-In-Time Recovery - Highgo Software Inc.
Aug 3, 2023 - Introduction This blog is aimed at beginners trying to learn the basics of PostgreSQL but already have some experience under their belt. For this tutorial, we...
time recovery highgorestoration techniquesusing postgresqlsoftware incvarious
https://www.highgo.ca/2019/06/12/pakistan-office-open/
Pakistan Office Open - Highgo Software Inc.
Aug 3, 2023 - I am very pleased and thrilled to inform that I have joined HighGo Software Inc as a VP of Development and General Manager Pakistan office. HighGo Software is...
highgo software incoffice openpakistan
https://www.highgo.ca/tag/regression-testing/
regression testing - Highgo Software Inc.
highgo software incregression testing
https://www.highgo.ca/2022/06/24/
June 24, 2022 - Highgo Software Inc.
june 24 2022highgo software inc
https://www.highgo.ca/2022/01/19/
January 19, 2022 - Highgo Software Inc.
january 19 2022highgo software inc
https://www.highgo.ca/tag/postgresconf-cn/
postgresconf.cn - Highgo Software Inc.
highgo software incpostgresconf cn
https://www.highgo.ca/2021/09/17/a-quick-test-for-postgres_fdw-batch-insertion/
A quick test for postgres_fdw batch insertion - Highgo Software Inc.
Aug 3, 2023 - 1. Overview In my previous blog, I briefly walked through how the bulk/batch insertion was done for postgres_fdw in PG14. In this blog, I am going to run some...
highgo software incquick testpostgres fdwbatchinsertion
https://www.highgo.ca/2020/06/01/optimizing-sql-simplifying-queries-with-window-functions/
Optimizing SQL: Simplifying Queries with Window Functions - Highgo Software Inc.
Aug 3, 2023 - The term “Window Functions” never really give much away in terms of the capability and various options they provide. So, it made sense to explore these and...
highgo software incoptimizing sqlwindow functionssimplifyingqueries
https://www.highgo.ca/2021/01/27/
January 27, 2021 - Highgo Software Inc.
2021 highgo softwarejanuary 27inc
https://www.highgo.ca/2019/09/30/key-management/
Key Management - Highgo Software Inc.
Aug 3, 2023 - Key management consists of four parts: key generation, key preservation, key exchange, and key rotation. Key Generation Only for the study of symmetric...
highgo software inckey management
https://www.highgo.ca/2023/07/28/
July 28, 2023 - Highgo Software Inc.
july 28 2023highgo software inc
https://www.highgo.ca/2019/11/07/replication-failover-with-pg_rewind-in-pg12/
Replication Failover with pg_rewind in PG12 - Highgo Software Inc.
Aug 3, 2023 - 1. Overview In the previous blog, we have discussed how to correctly set up streaming replication clusters between one master and one slave in Postgres version...
highgo software increplication failoverpgrewind
https://www.highgo.ca/category/postgresql/page/2/
postgresql - Highgo Software Inc. - Page 2
postgresql highgo softwareinc2
https://www.highgo.ca/2020/11/07/
November 7, 2020 - Highgo Software Inc.
2020 highgo softwarenovember 7inc
https://www.highgo.ca/author/ahsan-h/
Ahsan Hadi - Highgo Software Inc.
highgo software incahsanhadi
https://www.highgo.ca/tag/initialization/
initialization - Highgo Software Inc.
highgo software incinitialization
https://www.highgo.ca/2023/03/24/setup-an-all-in-one-ceph-storage-cluster-on-one-machine/
Setup an all-in-one Ceph Storage Cluster on one machine - Highgo Software Inc.
Aug 3, 2023 - 1. Overview Ceph is an open-source software-defined storage platform that implements object storage on a single distributed computer cluster and provides...
highgo software incceph storagesetuponecluster
https://www.highgo.ca/2020/01/10/how-to-build-and-debug-postgresql-12-using-latest-eclipse-ide-on-ubuntu-18-04/
How to build and debug PostgreSQL 12 using latest Eclipse IDE on Ubuntu 18.04 - Highgo Software Inc.
Aug 3, 2023 - 1. Overview This tutorial provides detailed instructions to help a newbie setup the building and debugging environment with the latest Eclipse IDE for C/C++...
ubuntu 18 04highgo software incpostgresql 12eclipse idebuild
https://www.highgo.ca/2023/08/25/customizing-sql-functions-in-postgresql-exploring-various-approaches/
Customizing SQL Functions in PostgreSQL: Exploring Various Approaches - Highgo Software Inc.
Aug 25, 2023 - 1. Overview PostgreSQL is a great open-source database management system that offers users a lot of options to meet their unique requirements. One of the...
highgo software incsql functionsexploring variouscustomizingpostgresql
https://www.highgo.ca/2020/08/10/postgresql-high-availability-the-considerations-and-candidates/
PostgreSQL High Availability: The Considerations and Candidates - Highgo Software Inc.
Aug 3, 2023 - Almost every organisation that I interact with wants a high availability system for PostgreSQL. This clearly depicts an active trend toward an increase in...
postgresql high availabilityhighgo software incconsiderationscandidates
https://www.highgo.ca/category/tde/
TDE - Highgo Software Inc.
highgo software inctde
https://www.highgo.ca/tag/sharding/
sharding - Highgo Software Inc.
highgo software incsharding
https://www.highgo.ca/2020/06/22/types-of-indexes-in-postgresql/
Types of Indexes in PostgreSQL - Highgo Software Inc.
Aug 3, 2023 - Finding relevant information quickly speeds up performance. For example, while reading a book in which you have to find a topic that you would like to read, if...
postgresql highgo softwaretypesindexesinc
https://www.highgo.ca/2022/03/31/parallel-commit-in-postgres-fdw/
parallel commit in postgres fdw - Highgo Software Inc.
Aug 3, 2023 - 1. Overview PostgreSQL is one of the greatest open source databases, not only because of the extensibility and SQL compliance but also the evolution of new...
fdw highgo softwareparallelcommitpostgresinc
https://www.highgo.ca/tag/sequential-scan/
sequential scan - Highgo Software Inc.
highgo software incsequentialscan
https://www.highgo.ca/2020/01/28/
January 28, 2020 - Highgo Software Inc.
2020 highgo softwarejanuary 28inc
https://www.highgo.ca/2023/06/16/deploy-pgpool-on-k8s-as-load-balancer/
Deploy Pgpool on K8S as Load Balancer - Highgo Software Inc.
Aug 3, 2023 - Introduction Following on my previous blog here, which outlines the procedure to deploy a metric server cron job to monitor an already deployed PostgreSQL...
load balancer highgosoftware incdeploypgpoolk8s
https://www.highgo.ca/2025/10/22/understanding-the-execution-plan-of-a-hash-join/
Understanding the Execution Plan of a Hash Join - Highgo Software Inc.
Oct 23, 2025 - A hash join is one of the most common join methods used by PostgreSQL and other relational databases. It works by building a hash table from the smaller input...
highgo software incexecution planunderstandinghashjoin
https://www.highgo.ca/tag/dbms/
DBMS - Highgo Software Inc.
highgo software incdbms
https://www.highgo.ca/author/chenze/
Neil Chen - Highgo Software Inc.
Neil is a junior software engineer working for the HighGo company. As a new person who is interested in PostgreSQL, he looks forward to sharing experiences and...
highgo software incneilchen
https://www.highgo.ca/2024/01/26/a-comprehensive-overview-of-postgresql-query-processing-stages/
A Comprehensive Overview of PostgreSQL Query Processing Stages - Highgo Software Inc.
Jan 26, 2024 - Introduction When you send a query to PostgreSQL, it will undergo several processing stages in the backend. Each of these stages has different responsibilities...
highgo software inccomprehensive overviewquery processingpostgresqlstages
https://www.highgo.ca/2021/06/04/hg-pgsql-1-7-and-hg-pgsql-2-3-released/
HG-PGSQL 1.7 and HG-PGSQL 2.3 Released - Highgo Software Inc.
Aug 3, 2023 - HighGo CA has released an update for its supported database systems on all supported platforms. HighGo Software Canada (a subsidiary of HighGo Software Inc)...
hg pgsql 12 3 releasedhighgo software inc7
https://www.highgo.ca/2023/09/22/exploring-various-ways-to-manage-configuration-parameters-in-postgresql/
Exploring Various Ways to Manage Configuration Parameters in PostgreSQL - Highgo Software Inc.
Sep 22, 2023 - 1. Overview PostgreSQL provides a configuration file postgresql.conf for end users to customize parameters. You may need to change some parameters to tune...
postgresql highgo softwareexploring variousconfiguration parameterswaysmanage
https://www.highgo.ca/2019/07/19/
July 19, 2019 - Highgo Software Inc.
2019 highgo softwarejulyinc
https://www.highgo.ca/2019/10/26/
October 26, 2019 - Highgo Software Inc.
2019 highgo softwareoctober 26inc
https://www.highgo.ca/category/uncategorized/
Uncategorized - Highgo Software Inc.
highgo software incuncategorized
https://www.highgo.ca/2020/08/21/how-to-setup-postgresql-on-an-ipv6-enabled-network/
How to setup PostgreSQL on an IPv6 enabled network - Highgo Software Inc.
Aug 3, 2023 - 1. Overview PostgreSQL is a great open source database, not only because it supports lot of database features, but also because it supports different network...
highgo software incsetuppostgresqlipv6enabled
https://www.highgo.ca/2022/10/
October, 2022 - Highgo Software Inc.
2022 highgo softwareoctoberinc
https://www.highgo.ca/2023/10/20/quick-overview-of-postgresqls-table-access-method/
Quick Overview of PostgreSQL’s Table Access Method - Highgo Software Inc.
Oct 26, 2023 - What is a Table Access Method? Table access method is the interface between the PostgreSQL core and data storage management. Since PostgreSQL 12, it is...
table access methodhighgo software incquick overview
https://www.highgo.ca/2023/06/06/using-nginx-as-a-postgresql-reverse-proxy-and-load-balancer/
Using NGINX as a PostgreSQL Reverse Proxy and Load Balancer - Highgo Software Inc.
Aug 3, 2023 - Introduction This blog will go over the use cases of setting up NGINX (Engine X) as both a reverse proxy and load balancer for PostgreSQL. NGINX is an...
load balancer highgousing nginxreverse proxysoftware incpostgresql
https://www.highgo.ca/2023/12/15/explore-table-access-method-capabilities-how-data-insertion-is-handled/
Explore Table Access Method Capabilities: How Data Insertion is Handled - Highgo Software Inc.
Dec 15, 2023 - Introduction In previous blogs, we talked about an overview of PostgreSQL's table access method API here , and how sequential scan is handled within this API...
table access methodhighgo software incexplorecapabilitiesdata
https://www.highgo.ca/2020/09/15/the-share-invalid-mechanism-of-cache-in-postgresql/
The Share Invalid mechanism of CACHE in PostgreSQL - Highgo Software Inc.
Aug 3, 2023 - PostgreSQL will create some catalog and other caches for each connection request to store some queried data locally, which can speed up query efficiency. If a...
postgresql highgo softwareshareinvalidmechanismcache
https://www.highgo.ca/2024/04/19/a-deeper-look-inside-postgresql-visibility-check-mechanism/
A Deeper Look Inside PostgreSQL Visibility Check Mechanism - Highgo Software Inc.
Apr 19, 2024 - What is Visibility? Simply put, the visibility refers to whether a row of data (Heap Tuple by default) should be displayed to the user in certain states,...
highgo software incdeeper lookvisibility checkinsidepostgresql
https://www.highgo.ca/2023/04/03/setting-up-a-postgresql-replica-server-locally/
Setting Up a PostgreSQL Replica Server Locally - Highgo Software Inc.
Aug 15, 2023 - Getting Started This blog is aimed at beginners who want to practice the fundamentals of database replication in PostgreSQL but who might not have access to a...
highgo software incsettingpostgresqlreplicaserver