Robuta

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/31/avoiding-identifying-and-dealing-with-postgresql-database-corruption-part-2/ Avoiding, Identifying, and dealing with PostgreSQL database corruption – Part 2 - Highgo Software... Aug 3, 2023 - This is the second of the two-part series of blogs about PostgreSQL data corruption. Part-1 discussed identifying the data corruption in PostgreSQL and lists... part 2 highgopostgresql databaseavoidingidentifyingdealing 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/avoiding-identifying-and-dealing-with-postgresql-database-corruption-part-1/ Avoiding, Identifying, and dealing with PostgreSQL database corruption – Part 1 - Highgo Software... Aug 3, 2023 - All the things that can happen to databases, corruption is not the one that happens frequently, but when it does it can result in major downtime and data loss.... postgresql databasepart 1highgo softwareavoidingidentifying 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/2024/08/23/how-to-utilize-postgresqls-jsonb-apis-as-a-simple-json-parser-for-your-extension/ How to Utilize PostgreSQL’s JSONB APIs as a Simple JSON Parser for Your Extension - Highgo Software... Aug 23, 2024 - Introduction In your PostgreSQL extension development based on the C language, you may come across a need to work with structured data like JSON. Naturally,... json parserhighgo softwareutilizejsonbapis 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.com/en/opensource/contribution Highgo Software Co., Ltd. 瀚高,瀚高数据库,国产数据库,信创数据库,国产数据库,国产化,数据库集群,Oracle兼容,Oracle替代,自主可控数据库,国产基础软件,PG,Postgresql software co ltdhighgo 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