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))
min | max | avg
1 | 38 | 7.4615463141373282
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
In response to
pgsql-patches by date
|Next:||From: Oleg Bartunov||Date: 2007-02-22 16:49:45|
|Subject: Re: First implementation of GIN for pg_trgm|
|Previous:||From: Markus Schiltknecht||Date: 2007-02-22 16:20:55|
|Subject: Re: tsearch in core patch, for inclusion|