O'Reilly Open Source Convention
Books Safari Bookshelf Conferences O'Reilly Network

Arrow Home
Arrow Registration
Arrow Speakers
Arrow Keynotes
Arrow Tutorials
Arrow Sessions
Arrow At-a-Glance
Arrow Wiki
Arrow BOFs
Arrow Events
Arrow Exhibitors
Arrow Sponsors
Arrow Hotel/Travel
Arrow Venue Map
Arrow See & Do
Arrow Tips for
Arrow Press
Arrow Mail List



Tsearch2: PostgreSQL Full Text Search Extension
George Essig, Web Developer, Federal Reserve Bank of St. Louis

Track: PostgreSQL
Date: Thursday, July 29
Time: 10:45am - 11:30am
Location: Salon H


Tsearch2, a contributed extension in PostgreSQL 7.4, provides fast indexed access for full text search queries. This talk will discuss Tsearch2's history and technology as well as how to install, configure, and optimize performance of the software. Tsearch2 supports relevance ranking, multilingual word stemming, HTML parsing, headline generation, boolean queries, stop words, and synonyms.

Tsearch2, written by Oleg Bartunov and Teodor Sigaev, utilizes advanced PostgreSQL features such as custom data types, operators, stored procedures, and GiST (Generalized Search Tree) indexes. A GiST index is a template indexing structure that allows domain experts to adhere to an interface and index custom data types. In particular, a custom data type, tsvector, is used to store a vector of word stems. A custom GiST index provides indexed access for the tsvector data type.

Download presentation file

O'Reilly Home | Privacy Policy

© 2004, O'Reilly Media, Inc.