Index on substring

From: Håvard Wahl Kongsgård <haavard(dot)kongsgaard(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Index on substring
Date: 2011-06-05 19:46:02
Message-ID: BANLkTi=fZXYB+=BKkswhWgckDKNr0t6jMQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, my database performance badly on substring comparison between two very
large tables.
In postgresql 8.4 is it possible to create a index on a substring, or must I
create an new field for the substring match ( and then create a new index
for that field)?

--
Håvard Wahl Kongsgård

http://havard.security-review.net/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Szymon Guz 2011-06-05 20:00:48 Re: Index on substring
Previous Message Joshua D. Drake 2011-06-05 19:01:25 Re: EnterpriseDB-xDBReplicationServer java process on OS X.