×

digoal

786 Reputation

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

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

digoal Posted blog

PostgreSQL Asynchronous Message practice — real-time feed system monitoring and response like in proactive e-commerce services — minute level to milli

In this article, we'll show you how to implement real-time feed system monitoring and response in proactive e-commerce services with PostgreSQL.

digoal Posted blog

PostgreSQL Business Data Quality Real-time Monitoring Practices

This article talks about the built-in statistics feature in PostgreSQL, which can meet the requirements of most business data quality monitoring scenarios.

digoal Posted blog

PostgreSQL Time-Series Best Practices: Stock Exchange System Database

In this article, we'll design a stock exchange system database using Alibaba Cloud's ApsaraDB for RDS PostgreSQL.

digoal Posted blog

PostgreSQL Time-Series Database Plug-in TimescaleDB Deployment Practices

This article will present an example of using PostgreSQL's TimescaleDB plug-in, which covers using PostGIS and TimescaleDB for a PG spatial-temporal database.

digoal Posted blog

PostgreSQL Time-Series Data Case: Automatic Compression over Time

In this article, we'll discuss a case of PostgreSQL time-series data by generating year-on-year and period-over-period comparisons.

digoal Posted blog

Real-time Statistical Analysis on Sliding Windows with PostgreSQL

In this article, we'll talk about real-time statistical analysis for PostgreSQL on any sliding window, including tracking sensors, crowds, and objects.

digoal Posted blog

On-demand Schemaless Slicing in PostgreSQL with TimescaleDB

In this article, we'll discuss the implementation of an on-demand slicing in PostgreSQL using the automatic slicing feature of the TimescaleDB plug-in.

digoal Posted blog

PostgreSQL App Massive FEED LOG Real-time Quality Statistics

In this article, we'll discuss a case of implementing real-time quality statistics with Rotate Partitioned Table on PostgreSQL.

digoal Posted blog

PostgreSQL Database Design for Pivot Data Analysis

This article discusses database design for audio/video/picture (pan-content) website data pivot analysis with ApsaraDB RDS for PostgreSQL and HybridDB for PostgreSQL.

digoal Posted blog

Optimizing Real-time Tagging on PostgreSQL

This article discusses several key optimization methods available for the tagging business scenario using PostgreSQL functions.

digoal Posted blog

Creating a Real-Time User Profile Recommendation System with PostgreSQL (2)

In this article, we will create a real-time user profile recommendation system (varbitx) based on Alibaba Cloud RDS for PostgreSQL.

digoal Posted blog

Creating a Real-Time User Profile Recommendation System with PostgreSQL (1)

In this article, we will create a real-time user profile recommendation system (varbitx) based on Alibaba Cloud RDS for PostgreSQL.

digoal Posted blog

Accelerating PostgreSQL Ad Hoc Query and Dictionary with RUM Index

This article discusses how you can accelerate PostgreSQL ad hoc query and dictionary (random field combination) through RUM index acceleration.

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.

Areas of Expertise

Following (0)

See All
Latest Comments
No series yet.