September 17-19, 2012

Westin Michigan Avenue Hotel, Chicago

Log in or Sign Up

Full-text search - seek and ye shall find

log in to bookmark this presentaton

Novice / Talk
September 18th 4 p.m. – 4:59 p.m.
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.

Abstract

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.