PostgreSQL Evangelist. [My Git](https://github.com/digoal/blog/blob/master/README.md)Follow
This article describes the range types introduced in PostgreSQL 9.2 and indexes for range types that significantly improve query performance.
This blog discusses the PostgreSQL community and the patch where PostgreSQL supports full-text searches of JSON-formatted content with tsvector.
This article discusses how PostgreSQL can use trigonometric functions to allow you to gain further insights about your data through these functions.
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.
This blog discusses Swinging Door Trending (SDT) algorithm and how you can use it in PostgreSQL for effective compression in Internet of Things applications.
This article describes the range types introduced in PostgreSQL 9.2 and indexes for range types that can significantly improve query performance.
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.
This blog article discusses several different method you can use to optimize the write and read operations of large databases using PostgreSQL.
This article shows you how to speed up the query of positive and negative relationships on a PostgreSQL database.
This article explores a potential solution for implementing a social "like" feature, similar to that of Facebook, by using PostgreSQL.
This article shows a quick demo on implementing graph search for searching and filtering student electives based on several criteria.
This article introduces the Smlar extension for PostgreSQL and its application in graph search for content communities such as forums.
This article discusses the implementation of graph search using the CTE syntax of PostgreSQL.
This article describes scenarios that are related message pushing and message consumption by using a 2048-letter-long message as an example.
This article explains how to store family relationships and quickly extract N-tier information for a typical graph application.
This article introduces LinkBench for PostgreSQL and shows you how to use it to run benchmark test for your database.
In this article, we discuss several real world implementations of PostgreSQL including Finance Risk Control, Police Criminal Detection, and Social Network Analysis.
In this article, we will explore how database and other similar technologies can be used to address crimes.
In this blog, we look at how statistical analysis can help enterprises determine the perfect product combination for marketing.
This article shows you how to use data pivoting on PostgreSQL to meet your various business needs.