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