Postgres Pro
Downloads
Home   >   mailing lists

Index on substring - Mailing list pgsql-general

From Håvard Wahl Kongsgård
Subject Index on substring
Date
Msg-id BANLkTi=fZXYB+=BKkswhWgckDKNr0t6jMQ@mail.gmail.com
Whole thread Raw
Responses Re: Index on substring  (Szymon Guz <mabewlun@gmail.com>)
List pgsql-general
Tree view
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/

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: EnterpriseDB-xDBReplicationServer java process on OS X.
Next
From: Szymon Guz
Date:
Subject: Re: Index on substring