Tsearch2 - full text extension for PostgreSQL

Tsearch2 - is the full text engine, fully integrated into PostgreSQL RDBMS.
Text Search is integrated into PostgreSQL 8.3 ! Read official text search documentation.

Official part:

• README.tsearch2 - Tsearch V2 Readme
• Tsearch V2 Introduction by Andrew J. Kopciuch
• Tsearch V2 User Guide by Brandon Craig Rhodes
• Tsearch V2 Reference by Brandon Craig Rhodes
• README.gendict - dictionary template generator
• tsearch-v2-7.3.tar.gz - latest stable version for 7.3.X (Dec 18, 2003)
  (since PostgreSQL 7.4 release tsearch2 is an offical contribution module)

Dictionaries:

Download ispell dictionaries ready to use with tsearch2. Additional dictionaries are welcome.

• ispell-english.tar.gz - from ispell-3.2.06/languages/english/english.*
• ispell-russian.tar.gz - from ftp://scon155.phys.msu.su/pub/russian/ispell/rus-ispell-0.99f6.tar.gz
• Italian Ispell dictionaries by Daniele Varrazzo
• new_slovak.rar, new_slovak_utf8.rar - submitted by John Sunavec, (old version)
• ispell-slovenian.tar.gz - submitted by ???
• ispell-french.tar.gz - submitted by Max Jacob (Built from the sources of Francais-GUTenberg http://www.unil.ch/ling/cp/frgut.html)
• ispell_utf8_french.tar.gz - ispell french (utf-8) dictionary (by Cedric)
• stemmer_utf8_french.tar.gz - snowball french stemmmer (utf-8) dictionary (by Cedric)
• catalan_ispell.tar.gz - from http://www.softcatala.org/prog146.htm
• tsearch2_espanol.tar.bz2 - spanish ispell dictionary in iso-8859-1 encoding (Denis Torres)
• tsearch2_german_utf8.zip - german ispell dictionary (UTF-8) by Markus Wollny
• New version of ispell-german-compound.tar.gz - german ispell dictionary with compound words support by Alexander Presber and Frank Wittig (README)
• chezh dictionaries, check also this article for more information.
• 61-tsearch-french-utf8.diff.gz - patch by Cedric Villemain, which adds utf8_french configuration (with snowball stemmer and list of french stop words) for fr_FR.UTF-8 locale
• dict_roman.tgz - dictionary for Roman numerals by Sergey Karpov
• dict_regex for 8.3 and later.

Development:

• tsearch_snowball_82-20070504.gz - yet another patch for snowball, use it with 8.2 release and current snowball stemmer. (size of libstemmer_c.tgz - 129287 bytes, md5 - 9b1a9f726e55b671b55e5c156316fb99)
• tsearch_snowball_82.gz - patch for 8.2 release, which updates snowball API. You need it only for the new stemmers from sbowball site !
• gin_tsearch2_81.gz - New version of previous patch which introduces GiN and tsearch support with VACUUM fix.
• gin_tsearch2_81.gz - patch to the current stable 8.1.X, which introduces Gin (Generalized Inverted Index) support to tsearch2. Also, the patch contains full utf-8 support, query rewriting and improved rank_cd function. Read Tsearch2WhatsNew for details.

• Tsearch2 WIKI
• Dictionary for integers:
  • dict_intdict.tar.gz - for 8.2 release and later
  • dict_intdict_old.tar.gz
  • README.intdict
  • dict_intdict-8.3.tgz - version for upcoming PostgreSQL 8.3.
• tsearch2 plugin for Ruby on Rails
• Chinese parser for tsearch2

• A Walkthrough for Making A Custom Dictionaries for tsearch2 by Ben Chobot
• Tsearch2 presentation (OSCON 2004) by George Essig
• How to use tsearch2 in Japanese by Junji TERAMOTO
• Tsearch2 and Unicode/UTF-8 by Markus Wollny
• Howto write my own parser for tsearch2 by Valli
• How to use tsearch2 with spelling correction by Christopher Kings-Lynne
• Czech UTF-8 support for Tsearch2 PostgreSQL 8.2+ by Petr Krontorad
• polish tsearch in 8.3
• Full-text search for Ukranian

• Implementing Full Text Indexing with PostgreSQL by Joshua D. Drake

• openfts-general
• pgsql-general

Authors (picture):

• Oleg Bartunov , Moscow, Moscow University, Russia
• Teodor Sigaev , Moscow, Moscow University, Russia

Text Search was sponsored by:

Blog Platform by jfg://networks, France

Enterprise DB

Local Search Engine by Nomao, France

Obsoleted patches

• tsearch2.82.tar.gz - this is a backport of tsearch2 from 8.2 development tree to 8.1.X. It contains full utf-8 support, query rewriting and improved rank_cd function. Read Tsearch2WhatsNew for details.
• tsearch2_stat.patch.gz - patch to tsearch2, it's possible to get words statistics ('stat' function) per document part.
• regprocedure_7.4.patch.gz - patch for tsearch2 (7.4), which makes dump/reload better. Andrew wrote a regprocedure_update.sql to update live database ( more details)
• tsearch-v2-7.3-order.tar.gz - experimental version for 7.3 with ordering function (needed for some operations) - Mar 26, 2004
• tsearch-v2.2.11.tar.gz - experimental version for 7.4.X with ordering function (needed for some operations) - Mar 26, 2004
• Patch for 7.4 with compound word support.(Dec 18, 2003) (use patch -p 0).

License:
Stable version, included into PostgreSQL distribution, is released under BSD license. Development version, available from this site, is released under the GNU General Public License, version 2 (June 1991).