Postgres as a search engine

This method ensures that items ranked high in multiple lists are given a high rank in the final list. It also ensures that items ranked high in only a few lists but low in others are not given a high rank in the final list. Placing the rank in the denominator when calculating score helps penalize the low ranking records. It’s also worth noting: $rrf_k: To prevent extremely high scores for items ra

[takahashim]

日本語だとpg_trgmじゃなくてpg_bigmにした方が良さそう。Postgres標準じゃないですが例えばAmazon RDSでは使えるようです

[arrowKato]

PostgreSQLは、検索系の処理を何でもさばけるという話。Full-text search with tsvector Semantic search with pgvector Fuzzy matching with pg_trgm Bonus: BM25

[softantenna]

Postgresをサーチエンジンとして使用する方法