Unverified50% confidenceFactExact time
pg_trgm is an official PostgreSQL extension that splits a string into trigrams made of three consecutive characters, and by comparing the proportion of trigrams shared by two strings it calculates a similarity score between 0 and 1, thereby tolerating typos, missing characters, or reversed word order.
1
Sources
50%
Confidence
Long-term
Relevance
10/14/2026
First Seen
Sources
Related Entities
Related Claims
Verifiedpgvector is an open-source extension for PostgreSQL that natively adds vector data types and similarity search capabilities to the relational database, supporting both exact nearest-neighbor and approximate nearest-neighbor (HNSW, IVFFlat index) retrieval modes.69% similarVerifiedPostgreSQL can support vector retrieval via pgvector.63% similarUnverifiedtsvector is a data type designed by PostgreSQL specifically for full-text search; it splits text into tokens and stores them normalized by position, thereby supporting stemming and position-related ranking.59% similarUnverifiedImmich 使用 pgvector（PostgreSQL 的向量相似度搜索扩展）存储 CLIP 特征向量59% similarUnverifiedPostgreSQL has a built-in tsvector for full-text search, along with plugins such as PGSearch that provide BM25-like capabilities.58% similar
Cite This Claim
Stable URI
https://kongchang.com/claim/1023225API
curl https://kongchang.com/api/v1/knowledge/claims/1023225MCP
get_claim(id=1023225)