On Thu, 02 Dec 2010 17:34:28 +0100, Dimitri Fontaine <dimi...@2ndquadrant.fr> wrote: > AI Rumman <rumman...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
