Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> 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