On Thu, 02 Dec 2010 17:34:28 +0100, Dimitri Fontaine <dimitri@xxxxxxxxxxxxxx> wrote: > AI Rumman <rummandba@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
