Re: Wildcard search support for pg_trgm - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Re: Wildcard search support for pg_trgm
Date
Msg-id AANLkTikPF5SC9aWHkmG8s3fL7mC5k87rhTMGZdu6c9Xs@mail.gmail.com
Whole thread Raw
In response to Re: Wildcard search support for pg_trgm  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
List pgsql-hackers
On Mon, Dec 13, 2010 at 12:14 AM, Dimitri Fontaine <dimitri@2ndquadrant.fr> wrote:
How different (and better) is it from wildspeed?

The general advantage is possibility of usage wildcard search and trigram similarity search using the same index.
I expect that GIN trigram index is slightly less space demanding, but slightly slower on search than wildspeed. Also, I expect GiST trigram index to be slower on search, but faster on updates. While I didn't check these assumptions in details.
I've lack of test datasets for sufficient testing, and I would like to ask community to help me with it. Because testing on dictionaries is good, but obviously not enough.

----
With best regards,
Alexander Korotkov.

pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: Extensions, patch v17
Next
From: Peter Eisentraut
Date:
Subject: Re: create tablespace fails silently, or succeeds improperly