BestHub
search
Sign in
Tag

pg_trgm

1 views collected around this technical thread.

JD Cloud Developers
JD Cloud Developers
Dec 24, 2021 · Databases

Boost Address Keyword Search with PostgreSQL: GIN, pg_trgm, and pg_bigm

This article explains how PostgreSQL's native full‑text search, GIN indexes, and extensions like pg_trgm, pg_bigm, and pg_jieba can dramatically improve the speed and accuracy of Chinese address keyword searches, offering a cost‑effective alternative to external search engines.

Chinese segmentationFull-Text SearchGIN index
0 likes · 6 min read
Boost Address Keyword Search with PostgreSQL: GIN, pg_trgm, and pg_bigm
Efficient Ops
Efficient Ops
Jul 9, 2017 · Databases

How Alibaba Scales Real‑Time Deduplication and Targeted Ads with PostgreSQL

This article explains how Alibaba Cloud leverages PostgreSQL’s GIN indexes, array types, and pg_trgm extension to achieve real‑time deduplication of massive guide articles, precise ad targeting, TOB profiling, arbitrary field combination, and fuzzy matching, delivering millisecond‑level latency while drastically reducing hardware requirements.

GIN indexPostgreSQLTOB profiling
0 likes · 18 min read
How Alibaba Scales Real‑Time Deduplication and Targeted Ads with PostgreSQL