Обсуждение: Full Text Partial Match at begining

AI Rumman <rummandba@gmail.com> writes:
> Is it possible to match "%text' in Postgresql 9 Full Text.

See http://www.sai.msu.su/~megera/wiki/wildspeed

--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support

On Thu, 02 Dec 2010 17:34:28 +0100, Dimitri Fontaine
<dimitri@2ndQuadrant.fr> wrote:
> AI Rumman <rummandba@gmail.com> writes:
>> Is it possible to match "%text' in Postgresql 9 Full Text.
>
> See http://www.sai.msu.su/~megera/wiki/wildspeed
>
> --
> Dimitri Fontaine
> http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support
I saw speed result of this and those are surprising. I saw source code,
too. Can be this index used directly on text column? I mean if we will
create this index for 100 characters long text it looks like the index will
take 100^2=10000, because it's set of all shifts.

--
----------
Radosław Smogura
http://www.softperience.eu