×

digoal

115 Reputation

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

Follow
Activities(10) Posts(10) Series(0) Areas of Expertise Following Followers

digoal Posted blog

Using RDS for PostgreSQL varbitx Extension for Real-Time Profile Applications

In this article, we will learn about the Alibaba Cloud ApsaraDB for RDS PostgreSQL varbitx extension for varbit and bit operation functions.

digoal Posted blog

Tagging Trillions of Users in Milliseconds with varbitx on PostgreSQL

In this article, we will explore how to use Alibaba Cloud RDS PostgreSQL varbitx stream tags for tagging trillions of users with any tags in milliseconds.

digoal Posted blog

Designs of a PostgreSQL Global ID Assignment (Data Dictionary) Service

In this article, we will be designing a global ID assignment service on PostgreSQL and comparing the performance of three different design approaches.

digoal Posted blog

Performance of PostgreSQL Multi-Field Random Combination Searches

In this article, we will explore how to optimize PostgreSQL multi-field and random combination searches with GIN, Bloom, and multiple B-tree indexes.

digoal Posted blog

Analyzing 1TB Table from Any Dimensions in Seconds with RDS PostgreSQL

With ApsaraDB for RDS PostrgreSQL, you can analyze 1TB tables from any dimensions in seconds, satisfying the requirements of statistical analysis.

digoal Posted blog

Supporting 200 Billion Data Records in a Single RDS PostgreSQL Instance

Varbitx, an extension provided by ApsaraDB for RDS PostgreSQL, enables real-time tagging for trillions of USER_TAGs using a single RDS PG.

digoal Posted blog

Double Eleven Technology Series: Replacing Word Segmentation with Regular Expression and Similarity

In this article, we will explore how we can implement fuzzy query and similarity-based query for text searching by using PostgreSQL.

digoal Posted blog

Double Eleven Technology Series: Logistics and Dynamic Path Planning

This article introduces how Alibaba optimizes logistics for the Double Eleven online shopping festival using PostgreSQL, Greenplum, and PostGIS.

digoal Posted blog

Double Eleven Technology Series: Word Segmentation and Index Searching

This article introduces how Alibaba uses PostgreSQL index searching and word segmentation technologies for its annual Double Eleven online shopping festival.

digoal Posted blog

Double Eleven Technology Series: Flash Sales Optimization on PostgreSQL

In this article, we will discover how Alibaba optimizes flash sales for its annual Double Eleven online shopping festival using advisory locks on PostgreSQL.

Areas of Expertise

Following (0)

See All
Latest Comments
No series yet.