On Mon, 19 Feb 2007, Guillaume Smet wrote:
On 2/19/07, Oleg Bartunov <email@example.com> wrote:
pg_trgm was developed for spelling corrrection and there is a threshold of
similarity, which is 0.3 by default. Readme explains what does it means.
Yes, I read it.
Similarity could be very low, since you didn't make separate column and
of the full string is used to normalize similarity.
Yep, that's probably my problem. Ignored records are a bit longer than
I tried the tip in README.pg_trgm to generate a table with all the words.
It can do the work in conjunction of tsearch2 and a bit of AJAX to
suggest the full words to the users. The reason why I was not using
tsearch2 is that it's sometimes hard to spell location names
The only problem is that it is still quite slow on a 50k rows words
table but I'll make further tests on a decent server this afternoon.
You need to wait GiN support.
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: firstname.lastname@example.org, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at