Enskri

PostgreSQL full-text search vs pg_trgm for a Q&A site

poze 2 months ago360 gadeen

4

Building search for a Q&A platform. Should I use tsvector/tsquery or the pg_trgm extension for fuzzy title matching? Content is multilingual.

Dyagnostik IA

Se IA ki fè l. Se pa yon repons — kominote a anba a konfime oswa korije l. Toujou verifye anvan ou fye l.

sqlpostgresql
poze 2 months ago

  • Thanks, this helped. Did you also try clearing the cache?

     — jamesetienne 2 months ago

1 Repons

3
✓
✓ Repons yo aksepte

For a multilingual Q&A site use tsvector with the simple configuration (no language-specific stemming) plus pg_trgm on the title for fuzzy matches. Combine ranks: ts_rank_cd for body, similarity() for title, weighted.

Konekte pou di lòt moun si li te mache.

answered 2 months ago

Sign in and verify your email to post an answer.