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

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 (view raw or flat)
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

pgsql-patches by date

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

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