Horton

Re: Wildcard search support for pg_trgm

Alexander Korotkov <aekorotkov@gmail.com>

View thread
From: Alexander Korotkov <aekorotkov@gmail.com>
To: Dimitri Fontaine <dimitri@2ndquadrant.fr>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2010-12-12T21:53:26Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Update contrib/pg_trgm for new GIN extractQuery API.

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.