Re: specific query (not all) on Pg8 MUCH slower than Pg7

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: specific query (not all) on Pg8 MUCH slower than Pg7
Дата
Msg-id 2210.1178640556@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: specific query (not all) on Pg8 MUCH slower than Pg7  (Alvaro Herrera <alvherre@commandprompt.com>)
Список 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 по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Best OS for Postgres 8.2
Следующее
От: 李彦 Ian Li
Дата:
Сообщение: Re: Best OS for Postgres 8.2