Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
Дата
Msg-id 4664814F.4050109@enterprisedb.com
обсуждение исходный текст
Ответ на Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x  (Gregory Stark <stark@enterprisedb.com>)
Ответы Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
Список pgsql-performance
Дерево обсуждения 
Gregory Stark wrote:
> Those plans look like they have a lot of casts to text in them. How have you
> defined your indexes? Are your id columns really text?

And did you use the same encoding and locale? Text operations on
multibyte encodings are much more expensive.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

В списке pgsql-performance по дате отправления:

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
Следующее
От: Kenneth Marshall
Дата:
Сообщение: Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x