Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Susan Russo wrote:
>> Next step is to initdb w/C Locale (tonight) (Thanks Tom et al.!).
> That's alternative to the pattern_ops index; it won't help you obtain a
> plan faster than this one.
No, but since their old DB was evidently running in C locale, this seems
like a prudent thing to do to avoid other surprising changes in behavior.
regards, tom lane