Month: January 2021

Enterprise PostgreSQL Solutions

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. Probably it is one of the most terrifying things for a DBA to come across and the best way to deal

In computing, a hash table (hash map) is a data structure that implements an associative array abstract data type, a structure that can map keys to values. A hash table uses a hash function to compute an index, also called a hash code, into an array of buckets or slots,

1. Introduction There are many approaches for PostgreSQL to retrieve the data back to the user. Depending on the user’s input query, the planner module is responsible for selecting the most optimum approach to retrieve the requested data. Sequential scan is one of these approaches that is mostly selected when

A table in PostgreSQL has a relfilenode value, which specifies the file name of the table on disk (except foreign table and partition table). In general, this value can be found in the relfilenode field of the pg_class table, but there are some specific tables whose query result in the

HighGo Software Canada (a subsidiary of HighGo Software Inc.) is pleased to release HighGo Postgres Server 2.1 General Availability (HG-PGSQL 2.1 GA) on its website https://www.highgo.ca/products/highgo-postgresql-server/2-1-2/. The GA release contains everything that was released with HG-PGSQL 2.0 beta few weeks earlier with the addition of some important bug fixes and