Dan Scott: Full-text search - seek and ye shall find

PostgreSQL's full-text search functionality offers data integrity, advanced search, and great performance, with thorough documentation. But getting started can be daunting. This session provides a friendly introduction to the basics of full-text search the PostgreSQL way. PostgreSQL's full-text search functionality offers data integrity, advanced search, and great performance, with thorough documentation. But getting started can be daunting. This session provides a friendly introduction to the basics of full-text search the PostgreSQL way. Topics covered will include: Quick start: full-text search demo in 10 minutes or less, Indexing basics: tsvector columns, and the triggers that maintain them, GIN and GIST indexes, Relevancy ranking, Stopwords, stemming, synonyms, Wildcards and Boolean algebra.

Length: 59:26

Views 256 Likes: 1

Recorded on 2012-09-17 at Postgres Open

Look for other videos at Postgres Open.

Tweet this video