2445 Reputation

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

Activities(50) Posts(56) Series(5) Areas of Expertise Following Followers
Areas of Expertise

Following (0)

See All

Followers (2)

See All

Range Types in PostgreSQL and GiST Indexes Increases Speed of MySQL Index Combine Queries

This article describes the range types introduced in PostgreSQL 9.2 and indexes for range types that significantly improve query performance.

PostgreSQL 10.0 Preview: Full-Text Search of JSON-Formatted Content

This blog discusses the PostgreSQL community and the patch where PostgreSQL supports full-text searches of JSON-formatted content with tsvector.

How You Can Use Trigonometric Functions in PostgreSQL to Obtain Further Insights

This article discusses how PostgreSQL can use trigonometric functions to allow you to gain further insights about your data through these functions.

Create an BRIN Index at a Fraction of the Normal Size

In this blog, we will look into why BTree indexes are not suitable for IoT, and how BRIN indexes are, and how the two of these indexes compare with each other.

Using the Swinging Door Trending Algorithm in PostgreSQL

This blog discusses Swinging Door Trending (SDT) algorithm and how you can use it in PostgreSQL for effective compression in Internet of Things applications.

Range Types in PostgreSQL and GiST Indexes

This article describes the range types introduced in PostgreSQL 9.2 and indexes for range types that can significantly improve query performance.

Optimizing Internet of Vehicles Data with the Window Function

This article describes how to optimize the data collected about the virtual tracks traveled by a vehicle by removing unnecessary data and separating data by vehicle.

Optimize Read and Writer speeds in IoT Scenarios

This blog article discusses several different method you can use to optimize the write and read operations of large databases using PostgreSQL.

Social Friend Relationship System Practice in PostgreSQL - Accelerating Queries of Positive and Negative Relationships

This article shows you how to speed up the query of positive and negative relationships on a PostgreSQL database.

PCC Social Media "Like" Scenario - Database Design and Performance Stress Testing

This article explores a potential solution for implementing a social "like" feature, similar to that of Facebook, by using PostgreSQL.

PostgreSQL Practices of Elective Selection Relation in Colleges

This article shows a quick demo on implementing graph search for searching and filtering student electives based on several criteria.

PostgreSQL Practices - Application of Graph Search in Content Communities

This article introduces the Smlar extension for PostgreSQL and its application in graph search for content communities such as forums.

PostgreSQL Graph Search Practices - 10 Billion-Scale Graph with Millisecond Response

This article discusses the implementation of graph search using the CTE syntax of PostgreSQL.

PostgreSQL Feed Systems Similar to Weibo - Design and Performance Metrics

This article describes scenarios that are related message pushing and message consumption by using a 2048-letter-long message as an example.

PostgreSQL Family Tree Application Practices - Graph Relation Storage and Search

This article explains how to store family relationships and quickly extract N-tier information for a typical graph application.

Facebook LinkBench Tests PostgreSQL Social Relation Profile Scenario Performance

This article introduces LinkBench for PostgreSQL and shows you how to use it to run benchmark test for your database.

Applying PostgreSQL Graph Database to Social Scenarios

In this article, we discuss several real world implementations of PostgreSQL including Finance Risk Control, Police Criminal Detection, and Social Network Analysis.

Defeating Human Traffickers with Technology

In this article, we will explore how database and other similar technologies can be used to address crimes.

Using HybridDB/PostgreSQL to Find the Best Product Combination for Marketing

In this blog, we look at how statistical analysis can help enterprises determine the perfect product combination for marketing.

Use Cases for Millisecond-Level Massive Multi-Dimensional Data Pivoting on PostgreSQL/GPDB

This article shows you how to use data pivoting on PostgreSQL to meet your various business needs.

Latest Comments

Raja_KT Commented on Optimizing Time Series Querying on Alibaba Cloud RDS for PostgreSQL

Good one. But this is specific to these specific scenarios. Will it be the same for RDS MySQL, MSSQL.....?