10456 Reputation

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

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

Following (0)

See All

Followers (16)

See All

Migration Synchronization of PostgreSQL Sequence

This short article explains the sample code for setting SQL for sequences in PostgreSQL.

Structure of PostgreSQL RUM Index

This short article discusses the structure of the PostgreSQL RUM Index with additional info not provided in the ctid (row number) of GIN posting list|tree.

An Introduction to the Machine Learning Algorithms of the PostgreSQL MADlib Graph

This short article introduces the Machine Learning Algorithms of the PostgreSQL MADlib Graph.

Character Set Configuration of PostgreSQL mysql_fdw

This article addresses one question, What can I do if unreadable code appears because the character set of MySQL is different from that of PostgreSQL?

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.

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.

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.

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.

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.

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.

ShardingSphere PostgreSQL Proxy-based Sharding

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

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.

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.

Methods of Importing Data to MySQL Servers in Batches

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

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.

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.

Modify Timezone through Alibaba Cloud RDS for PostgreSQL

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

Parameter Priority in PostgreSQL

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

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

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

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

This article reviews PostgreSQL Dynamic Inline Code with examples.

Latest Comments

5374541210554523 Commented on PostgreSQL: How to Optimize Spatial Index-based Query Performance for Multipolygon Data

请问第一张图是怎么做出来的?GiST R树索引就一层树吗?

profedsonbelem@gmail.com Commented on Create a Real-Time Data Exchange Platform with BottledWater-pg and Confluent

parabéns pelo sey post.

5295094317782498 Commented on PostgreSQL Time-Series Best Practices: Stock Exchange System Database

Thanks for the great article!What postgres configuration was used and on what hardware did it run?

5244987673819126 Commented on Using the Built-In and Custom Ranking Algorithms of PostgreSQL for Full-Text Searches

Hello, I am trying to solve the issue when I need more weight levels than just 4 and I found your article. Unfortunately I am not that experienced in the SQL, could you please explain a little bit more the first method with ts_vector? I mean I do not understand how to put everything together. Let's say I have tsquery which I want to rank. I call the cat_ranking(tsquery), where did you get the 'contains_element' please?

5868769402049331 Commented on Optimizations with Full-Text Search in PostgreSQL

Talking about PostgreSQL performance issues, I would like to add one more possible solution for locating bottlenecks and tunning the performance of slow queries - the visual PostgreSQL query analyzer can help you in solving all the mentioned issues https://www.devart.com/dbforge/postgresql/studio/