RES: Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries?

From: "Edson Carlos Ericksson Richter" <richter(at)simkorp(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Subject: RES: Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries?
Date: 2011-09-26 14:02:32
Message-ID: 001c01cc7c54$efd284b0$cf778e10$@com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)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(at)postgresql(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2011-09-26 14:12:55 Re: bytea insert difference between 8.3 and 9.x
Previous Message Jov 2011-09-26 13:59:41 Pg and compress