Re: What is impact of "varchar_opts"?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Edson Richter <edsonrichter(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: What is impact of "varchar_opts"?
Date: 2013-01-21 20:36:09
Message-ID: 10694.1358800569@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Edson Richter <edsonrichter(at)hotmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2013-01-21 21:23:50 Re: Running update in chunks?
Previous Message Edson Richter 2013-01-21 20:12:06 Re: What is impact of "varchar_opts"?