Highgo Software Inc.

4 min read 2022-03-19 05:49:15

Distributed Database With PostgreSQL – Atomic Commit Problems

1. Introduction If you are into distributed database research, especially one that is setup using Foreign Data Wrapper (FDW) + partitioned foreign

3 min read 2022-03-01 05:14:29

1. Overview Recently, I was working on an internal issue related with buffer manager in PostgreSQL, and I saw a typical use of the Lightweight lock

2 min read 2022-02-19 06:16:11

1. Introduction Last year I wrote a blog about PostgreSQL’s timeline concept, which is essential for executing Point In Time Recovery (PITR) back

3 min read 2022-01-29 06:46:45

1. Overview I recently investigated one internal issue which was related with snapshot and found there were some changes on transaction id and

13 min read 2022-01-20 05:31:05

Introduction On December 14-17, 2021, PostgresConf.CN & PGconf.Asia2021 (referred to as 2021 PG Asia Conference) was held online successfully and

4 min read 2021-12-11 05:35:44

1. Introduction Few weeks ago, I was tasked to have a detailed look inside PostgreSQL’s extended query protocol and study its internal mechanisms

3 min read 2021-11-27 07:31:52

1. Overview I have been working on an internal project based on PostgreSQL for a while, and from time to time, I need to run some specific test cases

3 min read 2021-11-02 03:53:38

1. Introduction In my previous blog here, I discussed about PostgreSQL’s point in time recovery where PostgreSQL supports an ability to recover

2 min read 2021-10-26 02:40:36

About the Event In November, 2020, PostgresConf.CN and PGconf.Asia2020 cooperatively organized 2020 PG Asia Conference online for the very first

2 min read 2021-10-16 05:42:08

1. Overview When I was working on some backup and recovery related features for a project based on Postgres, I noticed that there is file called

5 min read 2021-10-02 05:00:48

1. Introduction Recently I have been practicing the internals of PostgreSQL continuous archiving and the point in time recovery features that are

3 min read 2021-09-18 06:21:39

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

1 min read 2021-09-11 05:55:53

HighGo CA has released a routine update for its supported database systems on all supported platforms. HighGo Software Canada (a subsidiary of HighGo

4 min read 2021-09-04 03:57:08

1. Introduction Recently I have been tasked to familiarize myself with the Foreign Data Wrapper (FDW) interface API to build a new FDW capable of

3 min read 2021-08-21 06:19:12

1. Overview postgres_fdw has been existing in PostgreSQL for many years, and it was one of the most popular interfaces used in many extensions. such