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

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x
Дата
Msg-id 87ps4bl91g.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x  (Douglas J Hunley <doug@hunley.homeip.net>)
Ответы Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x  (Heikki Linnakangas <heikki@enterprisedb.com>)
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x  (Douglas J Hunley <doug@hunley.homeip.net>)
Список pgsql-performance
Дерево обсуждения 
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 you don't have a 7.4 install around to compare the plans do you?

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: dbt2 NOTPM numbers
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x