Re: specific query (not all) on Pg8 MUCH slower than Pg7 - Mailing list pgsql-performance

From Tom Lane
Subject Re: specific query (not all) on Pg8 MUCH slower than Pg7
Date
Msg-id 2210.1178640556@sss.pgh.pa.us
Whole thread Raw
In response to Re: specific query (not all) on Pg8 MUCH slower than Pg7  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-performance
Alvaro Herrera <alvherre@commandprompt.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

pgsql-performance by date:

Previous
From: Ron
Date:
Subject: Re: Best OS for Postgres 8.2
Next
From: 李彦 Ian Li
Date:
Subject: Re: Best OS for Postgres 8.2