Re: First implementation of GIN for pg_trgm - Mailing list pgsql-patches

> I didn't see any improvement in terms of size of the index (14 MB for
> 642 738 rows in the index in both cases) or speed.
> Our dictionary table contains 78367 words and its size is 3 MB.
>
> Did I miss something?
Comparing integers is cheaper than strings. Although it hasn't significant
matter for index scan.

> The attached patch adds a RECHECK too. It seems to work correctly but
> the RECHECK COND costs a lot of time :/.

:(

How long is average length of strings in table?
--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/