×

digoal

9620 Reputation

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

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

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.

digoal Posted blog

PostgreSQL: How libpq Helps Configure Multi-Backend Connection Preferences

In this article, the author explains how libpq can support configuring multiple backend connection preferences, including read-only, prefer-read, and prefer-write.

digoal Posted blog

Implicit Type Conversion of Any Types and Any Arrays on PostgreSQL

In this article, the author discusses the limitations of implicit type conversions in PostgreSQL and proposes some solutions based on any types.

digoal Posted blog

How to View Shared Buffer Statistics Using pg_buffercache

In this article, the author explains how to use pg_buffercache to view various metrics of a shared buffer in PostgreSQL.

digoal Posted blog

How to Build a Time-series Database for Prometheus Using pg_prometheus

In this article, the author explains how to use PostgreSQL as a backend database system for Prometheus using the pg_prometheus plugin developed by TimescaleDB.

digoal Posted blog

How to Use pg_receivewal with Synchronous Replication to Mirror Redo Logs

In this article, the author explains how to mirror redo logs in PostgreSQL using pg_receivewal with synchronous replication.

digoal Posted blog

How to Set Up libpq Failover and Load Balancing for JDBC Driver Layer

In this article, the author discusses libpq failover and load balancing JDBC driver layer in PostgreSQL.

digoal Posted blog

How to Write into a Database Using reWriteBatchedInserts Parameter

In this article, the author explains how to perform batch insert in PostgreSQL to write data into a database quickly.

digoal Posted blog

How to Use PostgreSQL log_fdw to Query Logs

In this article, the author explains how to use PostgreSQL log_fdw to query log data directly in ApsaraDB RDS for PostgreSQL.

digoal Posted blog

PostgreSQL v12: How pg_stat_statements Causes High-concurrency Performance Issues

In this article, the author discusses how enabling PostgreSQL pg_stat_statements in PG v12 causes high-concurrency performance issues.

digoal Posted blog

PostgreSQL: How ORG GIS FDW External Table Supports Pushdown

In this article, the author demonstrates the support for external table pushdown in PostgreSQL and explains how multiple data sources are supported.

digoal Posted blog

Alibaba Cloud: How to Use FIO to Test the IO Performance of ECS Local SSD and ESSD (Part 2)

In this article, the author explains testing the IO performance of Local SSD and ESSD storage types of ECS in Alibaba Cloud using FIO.

digoal Posted blog

How to Use FIO to Test the IO Performance of ECS Local SSD and ESSD (Part 1)

In this article, the author explains testing the IO performance of Local SSD and ESSD storage types of ECS in Alibaba Cloud using FIO.

Latest Comments