Answer
Full-text search uses tsvector and tsquery types with GIN or GiST indexes. Dictionaries handle stemming, tokenization, and stop-word removal.
Quick Answer
PostgreSQL full-text search: tsvector stores preprocessed searchable text (stemmed, stop words removed). tsquery defines a search query with operators. CREATE INDEX ON docs USING GIN(to_tsvector("english", content)) for efficient search. Query: WHERE to_tsvector("english", content) @@ to_tsquery("english", "postgres & performance"). Use ts_rank() for relevance scoring. For advanced needs, consider Elasticsearch.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ