| From: | Radosław Smogura <rsmogura(at)softperience(dot)eu> |
|---|---|
| To: | Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr> |
| Cc: | AI Rumman <rummandba(at)gmail(dot)com>, pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Full Text Partial Match at begining |
| Date: | 2010-12-02 19:37:17 |
| Message-ID: | 9b6dec96a89df3dbcf1786423f0974e3@smogura-softworks.eu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 02 Dec 2010 17:34:28 +0100, Dimitri Fontaine
<dimitri(at)2ndQuadrant(dot)fr> wrote:
> AI Rumman <rummandba(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | zhong ming wu | 2010-12-02 20:17:32 | pg_dump: Error message from server: ERROR: canceling statement due to conflict with recovery |
| Previous Message | Scott Ribe | 2010-12-02 19:16:29 | Re: Looking for auto starting procedures |