Re: What is impact of "varchar_opts"? - Mailing list pgsql-general

From Tom Lane
Subject Re: What is impact of "varchar_opts"?
Date
Msg-id 10694.1358800569@sss.pgh.pa.us
Whole thread Raw
In response to Re: What is impact of "varchar_opts"?  (Edson Richter <edsonrichter@hotmail.com>)
Responses Re: What is impact of "varchar_opts"?  (Edson Richter <edsonrichter@hotmail.com>)
List pgsql-general
Edson Richter <edsonrichter@hotmail.com> writes:
> Thanks, but I've found that some queries using LIKE operator uses table
> scan instead index unless it is defined with varchar_ops in the index...

You mean varchar_pattern_ops?  That's an entirely different animal.

            regards, tom lane


pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: Re: What is impact of "varchar_opts"?
Next
From: Richard Huxton
Date:
Subject: Re: Running update in chunks?