×

digoal

4519 Reputation

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

Follow
Activities(50) Posts(97) Series(9) Areas of Expertise Following Followers

digoal Posted blog

Three Things to Looking Forward to from PostgreSQL in 2020

In this post, Digoal presents his predictions for what we'll see for PostgreSQL in 2020.

digoal Posted blog

Store Operations Optimization: Search Acceleration over PostgreSQL Arrays, JSON and Internal Tag Data

This post describes performance optimization methods to improve store operations by accelerating equivalent and range searches over PostgreSQL Arrays, JSON and Internal Tag Data.

digoal Posted blog

PostgreSQL Similarity Search: Millisecond-level Similarity Search for Addresses, QA, POIs, and Other Text

This post outlines the design and performance of PostgreSQL Similarity Search and describes similarity searches for random texts and arrays to see how PostgreSQL standalone performs.

digoal Posted blog

PostgreSQL Application in Image Search and Video and Image Deduplication

This post describes how PostgreSQL Image Search Plug-in helps to accelerate image-based searches and also highlights how PostgreSQL helps to screen out duplicate videos.

digoal Posted blog

Keyword Analysis with PostgreSQL: Cosine and Linear Correlation Algorithms for Text Analysis

This article describes the application of PostgreSQL along with algorithms to extract keywords from a document for text (keyword) analysis.

digoal Posted blog

Keyword Analysis with PostgreSQL: Algorithms for Text Analysis with the Smlar Plug-in

This article provides an overview of the smlar plug-in and describes how it supports multiple similarity algorithms.

digoal Posted blog

Keyword Analysis with PostgreSQL: Algorithms for Text Analysis with RUM and Smlar

This post outlines different methods to find the similarity between documents in various scenarios and focuses on how different algorithms can be used to improve efficiency in such scenarios.

digoal Posted blog

The smlar Plug-in for Effective Retrieval of Massive Volumes of SimHash Data

This article explains how the PostgreSQL database along with smlar plug-in helps in efficiently retrieving massive volumes of SimHash data on the basis of the hamming distance.

digoal Posted blog

Similarity Algorithms: Effective Similarity Search in PostgreSQL

This post discusses how to calculate the similarity between arrays using algorithms. It focuses on similarity calculation for strings, images, and other types of data in PostgreSQL.

digoal Posted blog

Shopping Guide System Optimization: Application of E-Commerce Content Deduplication and Filtering

This post outlines several ways to filter duplicate e-commerce content and also describes how indexing helps to determine the similarity between documents.

digoal Posted blog

PostgreSQL Similarity Search Distributed Architecture: DBLink Asynchronous Call and Multi-machine Parallelism

This post outlines the design and practices for PostgreSQL similarity search distributed architecture and describes how you can perform a parallel query by using DBLink asynchronous calls.

digoal Posted blog

PostgreSQL Multi-meaning Array Retrieval and Condition Filtering

This post describes how can we efficiently search tags and filter records that match the tag's weighted value.

digoal Posted blog

How PostgreSQL UDF Can Accelerate the Performance of Compound Queries of Single- and Multi-value Fields

This article describes the methods to accelerate compound queries of single-value fields and multi-value fields over 100 times, focusing on PostgreSQL UDF implementation.

digoal Posted blog

Support for Encryption, Full-text Search, and Fuzzy Query of Multi-language Strings

This post describes how to perform fuzzy queries or full-text searches on data before it is encrypted and ensure that your database supports encrypted storage.

digoal Posted blog

PostgreSQL Responds to Fuzzy or Regular Expression-based Searches within Seconds

This article illustrates different optimization methods to accelerate performance under distinct fuzzy search scenarios including prefix, suffix or fully fuzzy search and regex search.

digoal Posted blog

PostgreSQL Fuzzy Searches vs. Regex Matches: A Performance Comparison

This article lays down the performance differences between PostgreSQL fuzzy searches and regex matches, and further suggests ways to ways for SQL Optimization.

digoal Posted blog

PostgreSQL Fuzzy Search Best Practices: Single-word, Double-word, and Multi-word Fuzzy Search Methods

This article describes PostgreSQL best practices to optimize full-text search, fuzzy search, regex matches, and custom fuzzy searches.

digoal Posted blog

Performance Optimization of Fuzzy Queries for Chinese Characters Using PostgreSQL trgm

This article describes how trgm, a powerful plugin significantly improves text search performance for fuzzy prefix and suffix queries as well as regexp matching.

digoal Posted blog

Efficiently Implementing Full-table and Full-field Fuzzy Search in Milliseconds with PostgreSQL

This article describes how to perform fuzzy searches for all the fields in a table using pg_trgm. It illustrates the implementation of a full-table and full-field fuzzy search with an example.

digoal Posted blog

Difficult Fuzzy Search: Principles of Unique GIN, GiST, SP-GiST, and RUM Indexes of PostgreSQL

This article describes how PostgreSQL helps to perform fuzzy prefix or suffix query and regexp query by using database indexes, including GIN, GiST, RUM, and other customized indexes.

Latest Comments