Archive for the ‘Indexing’ Category

Partial Word Search / Spell Check in PostgreSQL 9 using Trigram (trgm)

Thursday, February 16th, 2012

Assuming you only plan on using ASCII encoding, a very viable option may be to use the Trigram (pg_trgm) module: http://www.postgresql.org/docs/9.0/interactive/pgtrgm.html (more…)

Posted in Database, Indexing, PostgreSQL, Relational Databases, SQL | No Comments »

Full Text Search (FTS) in PostgreSQL 9.1 (Examples Included)

Monday, January 16th, 2012

This post is aimed at providing only the information necessary to rapidly understand and deploy Full Text Search into your PostgreSQL environment. For more documentation, I’d recommend checking out the following URLs:

  • http://linuxgazette.net/164/sephton.html
  • http://www.postgresql.org/docs/9.1/static/textsearch.html
  • http://www.slideshare.net/billkarwin/full-text-search-in-postgresql

(more…)

Posted in Database, Indexing, PostgreSQL, SQL | No Comments »