| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
| Cc: | Anton Melser <melser(dot)anton(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Plan differences |
| Date: | 2015-12-31 17:11:15 |
| Message-ID: | 14868.1451581875@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> writes:
> On 12/31/15 9:02 AM, Tom Lane wrote:
>> If you don't want to rebuild the whole database, you can create indexes to
>> support this by declaring them with COLLATE "C", or the older way is to
>> declare them with text_pattern_ops as the index opclass.
> Do you have to do anything special in the query itself for COLLATE "C"
> to work?
No.
> I didn't realize the two methods were equivalent.
Well, they're not equivalent exactly, but indxpath.c knows that either
way produces an index that will work for LIKE.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anton Melser | 2015-12-31 20:10:12 | Re: Plan differences |
| Previous Message | Jim Nasby | 2015-12-31 16:29:10 | Re: Plan differences |