> 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(at)sigaev(dot)ru
In response to
pgsql-patches by date
|Next:||From: Andrew Dunstan||Date: 2007-02-22 15:19:30|
|Subject: Re: tsearch in core patch, for inclusion|
|Previous:||From: Guillaume Smet||Date: 2007-02-22 14:00:32|
|Subject: Re: First implementation of GIN for pg_trgm|