X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8DF3CD1B19C for ; Wed, 19 May 2004 08:52:53 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 75387-03 for ; Wed, 19 May 2004 08:52:36 -0300 (ADT) Received: from sigma.informatik.hu-berlin.de (sigma.informatik.hu-berlin.de [141.20.20.51]) by svr1.postgresql.org (Postfix) with ESMTP id 48B64D1B18A for ; Wed, 19 May 2004 08:52:32 -0300 (ADT) Received: from informatik.hu-berlin.de (zwiebel [141.20.27.151]) (authenticated bits=0) by sigma.informatik.hu-berlin.de (8.12.10/8.12.9/INF-2.0-MA-SOLARIS-2.8) with ESMTP id i4JBpvAO027588 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 19 May 2004 13:51:58 +0200 (MEST) Message-ID: <40AB4A5D.9020903@informatik.hu-berlin.de> Date: Wed, 19 May 2004 13:51:57 +0200 From: "Raphael A. Bauer" User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Dan Field Cc: pgsql-sql@postgresql.org Subject: Re: Very slow search using basic pattern matching References: <20040518161256.GA911@wolff.to> <55B02154-A988-11D8-9565-000A958E367A@llgc.org.uk> In-Reply-To: <55B02154-A988-11D8-9565-000A958E367A@llgc.org.uk> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/163 X-Sequence-Number: 17877 Dan Field wrote: > Is there any documentation available on how to go about creating these > indexes on my text fields? > > I'm at a bit of a loss here, Google is failing me sadly http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ We made quite good experiences with tsearch2. The problem for you could be that the case sensititity gets lost. Raph