11865 Reputation

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

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

Following (0)

See All

Followers (17)

See All

The Autonomous and Controllable O&M of Alibaba Cloud MyBase

This article describes how to install software, create a privileged account, view database logs, and modify any parameters with Alibaba Cloud MyBase.

PostgreSQL Convergence Filtering Optimization for Segment SQL with Multiple Range Conditions

This article discusses convergence conditions when there are multiple range conditions (with examples).

Best Practices for PostgreSQL Time Series Database Design

This article discusses databases in time series scenarios (with examples and demos).

PostgreSQL Recursive Query – Examples of Depth-First and Breadth-First Search

This article shows examples of depth-first and breadth-first searches.

The Scale up and Scale down of PostgreSQL Hash Partition Table

This article explains how to scale the PostgreSQL Hash partition table up and down (with examples).

Partition Table of PostgreSQL Hash and Partition ID Calculation

This article discusses the partition table of PostgreSQL Hash and partition ID calculation (with several examples).

Usage of PostgreSQL Recursive Queries in Group Merging

This short article reviews PostgreSQL recursive queries in group merging with examples.

How PostgreSQL Returns a Dynamic Number of Columns: Row-Column Convert

This article reviews some scenarios where users want an SQL statement to return a dynamic number of columns, including examples.

PostgreSQL Random Sampling Application - table sample, tsm_system_rows, and tsm_system_time

This short article reviews PostgreSQL Random Sampling Application with examples.

How to Convert a PostgreSQL Time Interval to a Numeric

This short article explains how to convert a numeric value-interval to numeric.

PostgreSQL SSL Certificate Configuration

This article mainly discusses how to prevent Intermediate attackers and how to configure cert using certificates without password login.

How to Convert a PostgreSQL Time Interval to a Numeric Value

This short article explains how to convert a numeric value-interval to numeric.

PostgreSQL group x, sort by y, and get (N dynamic) Records for Each Group-Subquery + Subquery Aggregation Use

This short article explains PostgreSEL group filtering and aggregation usage.

Use Mixed Storage of Rows and Columns in PostgreSQL Zedstore

This article discusses the background of zedstore and some usage examples.

PostgreSQL Optimized Case – Where a Field Range Order by B Field Sort Limit X

This short article explains a PostgreSQL optimization case.

How to Solve the Performance Problem of Deduplication Caused by Multi-Column Grouping in Window Queries

This article discusses Recursive Resolution and the Weighted Scan of the Sort Field.

PostgreSQL-Based Automatic Performance Diagnosis and Optimization

This short article discusses Postgres Query Analysis and optimization.

PostgreSQL plpgsql Debug - Black Screen and Text Mode Storage Procedure Debugging

This short article explains the pgadmin plpgsql debugging storage procedure.

General Usage of PostgreSQL hll in Retention and UV Statistics

This short article explains retention and UV statistics.

PostgreSQL Multi-Tenant Usage – Multi-Schema Batch Execution of DDL Scripts

This short article addresses a common issue of working batches when DDL scripts need to be executed in multiple tenants.

Latest Comments

Pointofviewer Commented on Best Practices for PostgreSQL Time Series Database Design

This Blog is Appreciable and very helpful, Thankyou for Sharing with us https://pointofviewer.com/

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?