Re: How to boost performance of queries containing pattern matching characters

From: Artur Zając <azajac(at)ang(dot)com(dot)pl>
To: "'Richard Huxton'" <dev(at)archonet(dot)com>
Cc: <gnanam(at)zoniac(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: How to boost performance of queries containing pattern matching characters
Date: 2011-02-14 08:09:55
Message-ID: 003d01cbcc1e$91241fa0$b36c5ee0$@ang.com.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> Looks like you've almost re-invented the trigram module:
> http://www.postgresql.org/docs/9.0/static/pgtrgm.html

I didn't know about this module.
Idea to use three letters strings and use Full Text Search is the same, but
the rest is not.

Is the idea to use similarity for this problem is really correct? How should
be query constructed to return really all records matching ILIKE criteria?

-------------------------------------------
Artur Zajac

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message dba 2011-02-14 11:33:12 performance issue in the fields.
Previous Message david 2011-02-14 08:02:39 Re: choosing the right RAID level for PostgresQL database