Postgres Pro
Downloads
Home   >   mailing lists

RES: Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries? - Mailing list pgsql-general

From Edson Carlos Ericksson Richter
Subject RES: Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries?
Date
Msg-id 001c01cc7c54$efd284b0$cf778e10$@com.br
Whole thread Raw
In response to Re: Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries?  (Gregg Jaskiewicz <gryzman@gmail.com>)
Responses RES: Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries?
List pgsql-general
Tree view

Thanks for the tip, unfortunately, split it does not work for me, since it’s a free text field, that users fill as they wish...

But looking most slow queries, this one pops up with more frequency...

 

So GIST would work; I’ll give a try.

 

Regards,

 

Edson.

 

 

 

De: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] Em nome de Gregg Jaskiewicz
Enviada em: segunda-feira, 26 de setembro de 2011 10:01
Para: Edson Carlos Ericksson Richter
Cc: pgsql-general@postgresql.org
Assunto: Re: [GENERAL] Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries?

 

You can always store it divided in the database into two columns. 

Gist could also work for you. 

 

Attachment

pgsql-general by date:

Previous
From: Jov
Date:
Subject: Pg and compress
Next
From: Merlin Moncure
Date:
Subject: Re: bytea insert difference between 8.3 and 9.x