Re: grep -f keyword data query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hiroyuki Sato <hiroysato(at)gmail(dot)com>
Cc: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: grep -f keyword data query
Date: 2015-12-28 00:36:47
Message-ID: 13472.1451263007@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hiroyuki Sato <hiroysato(at)gmail(dot)com> writes:
> Sorry, I re-created my questions. I was mis-pasted query log on previous
> question.
> (@~ operator is PGroonga extension (http://pgroonga.github.io))
> [ "like" is actually the operator of interest ]

Ah. You might get some good results with trigram indexes (ie,
contrib/pg_trgm and a GIST or GIN index). See

http://www.postgresql.org/docs/9.4/static/pgtrgm.html

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hiroyuki Sato 2015-12-28 02:00:58 Re: grep -f keyword data query
Previous Message Hiroyuki Sato 2015-12-27 23:53:38 Re: grep -f keyword data query