Re: First implementation of GIN for pg_trgm

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>
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 15:00:29
Message-ID: 45DDB00D.1040402@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2007-02-22 15:19:30 Re: tsearch in core patch, for inclusion
Previous Message Guillaume Smet 2007-02-22 14:00:32 Re: First implementation of GIN for pg_trgm