Skip site navigation (1) Skip section navigation (2)

Re: First implementation of GIN for pg_trgm

From: "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
To: "Teodor Sigaev" <teodor(at)sigaev(dot)ru>
Cc: pgsql-patches <pgsql-patches(at)postgresql(dot)org>, "Oleg Bartunov" <oleg(at)sai(dot)msu(dot)su>
Subject: Re: First implementation of GIN for pg_trgm
Date: 2007-02-22 16:42:49
Message-ID: 1d4e0c10702220842k34b0d216re263eed3063a7360@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-patches
On 2/22/07, Teodor Sigaev <teodor(at)sigaev(dot)ru> wrote:
> How long is average length of strings in table?

test=# SELECT MIN(length(word)), MAX(length(word)), AVG(length(word))
FROM lieu_mots_gin;
 min | max |        avg
-----+-----+--------------------
   1 |  38 | 7.4615463141373282
(1 row)

I don't see how to have a more precise similarity without having the
number of entries registered by the indexed value somewhere.

I think it can be interesting for other flavours of GIN usage. Is
there a way to add the number of entries of the considered indexed
item to the consistent prototype without adding too much overhead and
complexity?

--
Guillaume

In response to

Responses

pgsql-patches by date

Next:From: Oleg BartunovDate: 2007-02-22 16:49:45
Subject: Re: First implementation of GIN for pg_trgm
Previous:From: Markus SchiltknechtDate: 2007-02-22 16:20:55
Subject: Re: tsearch in core patch, for inclusion

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group