Blog and News

Intelligent Data Foundation for the AI Era

PGConf.dev 2026: Why It Remains My Favorite PostgreSQL Conference

About PGConf.dev PGConf.dev is an annual developer event focused entirely on contributing to the…

Understanding PostgreSQL REPACK Through repack.c

REPACK is a new PostgreSQL 19 feature for physically compacting a table by rewriting it into new…

Understanding ALTER TABLE Behavior on Partitioned Tables in PostgreSQL

Partitioned tables are a core PostgreSQL feature, but one area still causes regular confusion—even…

Understanding the Execution Plan of a Hash Join

A hash join is one of the most common join methods used by PostgreSQL and other relational…

HighGo’s Patch to Bring GB18030-2022 to PostgreSQL

PostgreSQL and GB18030-2022 Support PostgreSQL supports GB18030 as a client-side encoding. A…

Highlights from PostgreSQL Conference 2024 in Seattle

Introduction PostgreSQL Conference was held on November 6th and 7th, 2024 as part of PASS Data…

Table Access Method: How Data Update is Handled in PostgreSQL

Introduction In previous blogs, we talked about an overview of PostgreSQL’s table access method…

How to Utilize PostgreSQL’s JSONB APIs as a Simple JSON Parser for Your Extension

Introduction In your PostgreSQL extension development based on the C language, you may come across a…

Understand PostgerSQL’s Portal – Executor vs Process Utility

Introduction When you send a query to PostgreSQL, it normally would go through stages of query…

PGConf.dev 2024: Shaping the Future of PostgreSQL in Vancouver

Introduction For the first time ever, PGConf.dev (previously known as PGCon from 2007 to 2023) has…

2021 PG Asia Conference Delivered Another Successful Online Conference Again!

Introduction On December 14-17, 2021, PostgresConf.CN & PGconf.Asia2021 (referred to as 2021 PG…

PostgresConf.CN and PGConf.Asia 2021 (China Branch) Join Forces Again to Bring You the Best Conference in Asia!

About the Event In November, 2020, PostgresConf.CN and PGconf.Asia2020 cooperatively organized 2020…

HG-PGSQL 1.8 and HG-PGSQL 2.4 Released (Sep 3, 2021)!

HighGo CA has released a routine update for its supported database systems on all supported…

HG-PGSQL 1.7 and HG-PGSQL 2.3 Released

HighGo CA has released an update for its supported database systems on all supported platforms…

HighGo CA released second major version of Community PostgreSQL release

HighGo Software Canada (a subsidiary of HighGo Software Inc.) is pleased to release HighGo Postgres…