optimizing LIKE '%2345' queries - Mailing list pgsql-performance

From Gene
Subject optimizing LIKE '%2345' queries
Date
Msg-id 430d92a20607021450i1d228350j292d68e987ed58de@mail.gmail.com
Whole thread Raw
Responses Re: optimizing LIKE '%2345' queries  (Mario Weilguni <mweilguni@sime.com>)
Re: optimizing LIKE '%2345' queries  (Tarhon-Onu Victor <mituc@iasi.rdsnet.ro>)
List pgsql-performance
Is there any way to create a reverse index on string columns so that
queries of the form:

where column like '%2345';

can use an index and perform as fast as searching with like '2345%'?

Is the only way to create a reverse function and create an index using
the reverse function and modify queries to use:

where reverse(column) like reverse('%2345') ?

thanks

--
Eugene Hart
Cell: 443-604-2679

pgsql-performance by date:

Previous
From: "Jaime Casanova"
Date:
Subject: Re: FWD: Update touches unrelated indexes?
Next
From: "Craig A. James"
Date:
Subject: Sort order in sub-select