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: [email protected] [mailto:[email protected]] Em nome de Gregg Jaskiewicz Enviada em: segunda-feira, 26 de setembro de 2011 10:01 Para: Edson Carlos Ericksson Richter Cc: [email protected] 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.
smime.p7s
Description: S/MIME cryptographic signature
