×
Community Blog Series PostgreSQL Similarity Search
+ New Series

PostgreSQL Similarity Search

This series outlines the practices for PostgreSQL similarity search.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

Loading more…