Re: String searching

From: Jonathan Vanasco <postgres(at)2xlp(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: String searching
Date: 2014-11-18 16:59:39
Message-ID: 8A1C889C-AFFF-4D90-A0CD-E9765873C472@2xlp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Nov 18, 2014, at 11:49 AM, Robert DiFalco wrote:

> As far as I can tell, the trigram extension would be the easiest way to implement this. It looks like I wouldn't need to mess with vectors, etc. It would just look like a standard index and query, right? It seems that if I need something more powerful in the future that I could always move to ElasticSearch, Sphinx, or something similar.

I just followed the instructions in the docs to create the index, and ran ANALYZE on the table before running a standard "like" SELECT.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2014-11-18 18:01:34 Re: String searching
Previous Message Robert DiFalco 2014-11-18 16:49:37 Re: String searching