×

digoal

10228 Reputation

PostgreSQL Evangelist. [My Git](https://github.com/digoal/blog/blob/master/README.md)

Follow
Activities(50) Posts(211) Series(11) Areas of Expertise Following Followers

digoal Posted blog

PostgreSQL Multi-replica Wait Behavior, Transaction Snapshots, and Data Visibility

In this article, you’ll learn about the multi-replica wait behavior of PostgreSQL by performing multiple synchronous tests.

digoal Posted blog

HA Protection Configuration of ApsaraDB RDS for PostgreSQL – Maximum Protection, Availability, and Performance

The article explains the process of configuring the protection level of ApsaraDB RDS for PostgreSQL to ensure maximum availability and high performance.

digoal Posted blog

Solution to Ensure Availability and Reliability (rpo,rto) of PostgreSQL Two-node Stream Replication

This article explains how to ensure availability and reliability of PostgreSQL with a semi synchronous feature also known as two node stream replication process.

digoal Posted blog

How Does PostgreSQL Maintain Heartbeat and Support Automatic Upgrade and Synchronization

UDF customization can help prevent the blocking of heartbeat and support automatic upgrade and degradation in synchronous or asynchronous mode.

digoal Posted blog

SQL Server (MSSQL) Migration to PostgreSQL Timestamp

The article describes how to track the storage records for insert and update timestamps in PostgreSQL using the Virtual columns and Trigger tracking methods.

digoal Posted blog

PostgreSQL Quickly Converts All Native Partition Tables to Ordinary Tables

In this article, the author explains how to instantly convert all native partition tables to ordinary tables using PostgreSQL.

digoal Posted blog

ShardingSphere PostgreSQL Proxy-based Sharding

The article describes how to implement horizontal partitioning in PostgreSQL using ShardingSphere, a database middleware solution.

digoal Posted blog

User Preference Recommendation System - PostgreSQL Approximate Computing Application

The article explains how to use the PostgreSQL HLL plug-in to build a user recommendation system, along with the differences between different design techniques.

digoal Posted blog

Read/Write Splitting Configuration for ApsaraDB RDS for PostgreSQL 12 using pgpool

The article describes the step-by-step procedure of read/write splitting in ApsaraDB RDS for PostgreSQL 12 using the pgpool tool.

digoal Posted blog

Methods of Importing Data to MySQL Servers in Batches

The article lists the two techniques of importing data to MySQL servers, along with examples.

digoal Posted blog

Making PostgreSQL Compatible with MySQL Tinyint, Unsigned Int, Zerofill – Domain and Lpad

This short article explains how to make PostgreSQL compatible with MySQL Tinyint, Unsigned Int, Zerofill, and more.

digoal Posted blog

A Method to Make MySQL Bit(n) Compatible with PostgreSQL

This short article explains how to make MySQL Bit(n) compatible with PostgreSQL by filling 1 when out of range and 0 when within range.

digoal Posted blog

Modify Timezone through Alibaba Cloud RDS for PostgreSQL

This short article explains how to modify Timezone through Alibaba Cloud RDS for PostgreSQL.

digoal Posted blog

Parameter Priority in PostgreSQL

This short article explains configurable portals and parameter priority in PostgreSQL.

digoal Posted blog

Solution for the PostgreSQL Roaringbitmap UID Overflows Beyond Int4 (32 Bytes) – Offset

This short article explains formulas for the bitmap extension package of PostgreSQL.

digoal Posted blog

PostgreSQL Dynamic Inline Code: Code Calls in Dynamic Stored Procedure – Client Stored Procedure Version Control

This article reviews PostgreSQL Dynamic Inline Code with examples.

digoal Posted blog

PostgreSQL Business Function Code Version Control – Back Up Stored Procedures and Function Codes to Apache Subversion and GitHub Automatically

This article explains how to back up stored procedures and function codes to Apache Subversion and GitHub with examples.

digoal Posted blog

Insert and Update Time of PostgreSQL Trace Record (Row and Tuple) – SPI Moddatetime Trigger

This article explains how to track the write time and last update time of the record with examples.

digoal Posted blog

How to Prevent Downstream Timeline Errors Caused by Primary/Standby Switchover

In this article, the author explains how to prevent downstream timeline errors arising during primary/standby database switchover.

digoal Posted blog

How to Avoid Timeline Errors during Database Switchover Based on Asynchronous Streaming Replication

In this article, the author explains how to maintain accurate databases by avoiding timeline errors while performing primary database switchover in a high-availability architecture.

Latest Comments