Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Special index for "like"-based query - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] Special index for "like"-based query
Date
Msg-id CAKFQuwaAPR0_ki2OPGwXtK1MzpLECZHeDnd1Rkvb3zh7_Vdtag@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Special index for "like"-based query  (Job <Job@colliniconsulting.it>)
Responses Re: [GENERAL] Special index for "like"-based query
R: [GENERAL] Special index for "like"-based query
List pgsql-general
Tree view
On Thu, Dec 29, 2016 at 4:21 PM, Job <Job@colliniconsulting.it> wrote:
Hello,

in Postgresql 9.6 we have a query running on a very large table based, in some cases, on a like statement:

... WHERE FIELD='CODE' OR FIELD LIKE 'CODE_%'

Which type of index can i create to speed to the search when the "like" case happens?

​GIST​

pgsql-general by date:

Previous
From: Tim Uckun
Date:
Subject: Re: [GENERAL] Performance PLV8 vs PLPGSQL
Next
From: Tomas Vondra
Date:
Subject: Re: [GENERAL] Special index for "like"-based query