> -Mensagem original-
> De: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] Em nome de Marti Raudsepp
> Enviada em: segunda-feira, 26 de setembro de 2011 17:42
> Para: Edson Carlos Ericksson Richter
> Cc: pgsql-general@postgresql.org
> Assunto: Re: [GENERAL
> -Mensagem original-
> De: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] Em nome de Marti Raudsepp
> Enviada em: terça-feira, 27 de setembro de 2011 09:59
> Para: Alban Hertroys
> Cc: PG-General Mailing List
> Assunto: Re: [GENERAL] Does postgresql 9.0.4
> -Mensagem original-
> De: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] Em nome de Harald Fuchs
> Enviada em: terça-feira, 27 de setembro de 2011 07:01
> Para: pgsql-general@postgresql.org
> Assunto: Re: [GENERAL] Does postgresql 9.0.4 use index on PREF
This message has been digitally signed by the sender.
RES___GENERAL__Does_postgresql_9_0_4_use_index_on_PREFIX_SUFFIX_queries_.eml
Description: Binary data
-
Hi-Tech Gears Ltd, Gurgaon, India
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> -Mensagem original-
> De: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] Em nome de Marti Raudsepp
> Enviada em: segunda-feira, 26 de setembro de 2011 17:42
> Para: Edson Carlos Ericksson Richter
> Cc: pgsql-general@postgresql.org
> Assunto: Re: [GENERAL
Sorry, Gregg. I did not noticed I was disturbing...
Can you please tell me what you mean by "top posting"? I've created an
specific topic for this discussion, and I'm not using "urgent" or html
format... so I suppose that I've been following the rules...
BTW, I've repeated the query to easy peo
Because the error message saying so (I do use pgAdmin III):
"An error has occurred:
ERROR: the datatype character varying has no standard operator class for
"gist" access method
HINT: You should specify na operator class for the index or define one
standard operator class for the data type."
(I'
-general@postgresql.org
Assunto: RES: [GENERAL] Does postgresql 9.0.4 use index on PREFIX%SUFFIX
queries?
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
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-ow...