Tsearch2

Tsearch V2 - full text extension for PostgreSQL

Official Text Search Documentation Russian introduction to FTS

Text Search

• unaccent filtering dictionary - remove accents from input text
• FTS Notes - notes about FTS
• Tsearch2 83 changes - changes from tsearch2 to 'text search'
• Tsearch 84 - what's done and planned for PostgreSQL 8.4

Tsearch2 (OLD)

Official home page delicious page

• Tsearch V2 Readme - work in progress
• Tsearch V2 Notes - various notes about tsearch v2
• Tsearch V2 internals - explanation of tsearch2's internals
• tsearch-v2-intro - tsearch v2 intro docs
• Tsearch V2 compound words - support for compound words in Tsearch2
• Gendict tutorial - dictionary template generator for tsearch2
• Thesaurus dictionary
• FTS PGCon2007 (PDF,910Kb) - FTS presentation( PGCon 2007, Ottawa, Canada)
• FTS Todo - TODO for built-in FTS
• [[FTS_Upgrade?]] - upgrade from tsearch2 to FTS
• Tsearch2 TODO - TODO for Tsearch2

Miscellaneous

• pgweb cfg - example tsearch2 configuration for search.postgresql.org
• tsearchd - full text search daemon for PostgreSQL (not supported !)(download)
• tsearch2slides - "Gentle introduction to tsearch2" (for 10-th PostgreSQL Anniversary Summit,Toronto, 2006), Abridged version (PDF)

Tsearch2 8.2dev

Tsearch2WhatsNew - new features in 8.2 release

UTF-8 support

UTF-8 is fully supported! (tested with russian,greek)

initdb -D /usr/local/pgsql-dev/data.el_utf8 --locale=el_GR.utf8

iconv -f iso-8859-7 -t utf-8 ......

set client_encoding='ISO-8859-7';

• DONE! tsearch2UTF8Test - current problems. Seems, we passed all tests.
• DONE! ispell interface supports utf8 !
• DONE! snowball stemmer doesn't yet supported :)
  (download stem_UTF_8_LANG.{c,h} from libstemmer and use Gendict to produce UTF-8 snowball stemmer)
  

New ranking function

• NewExtentsBasedRanking

Misc. functions

• GetCovers
• ExtentsBasedHeadline