RE : RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues

Поиск
Список
Период
Сортировка
От Mouhamadou Dia
Тема RE : RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues
Дата
Msg-id BB6605E56C79CB4FA6CA491B706FBB210112DD@cpt127.magrit.int
обсуждение исходный текст
Ответ на Re: RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues  (Heikki Linnakangas <heikki@enterprisedb.com>)
Список pgsql-bugs
Дерево обсуждения 
Sorry,
This output is coming from PG 8.1.19
I'm attaching the one that is coming from 8.2.4
Thanks and sorry for the confusion


-----Message d'origine-----
De : Heikki Linnakangas [mailto:hlinnaka@gmail.com] De la part de Heikki Linnakangas
Envoyé : 6 août 2007 15:32
À : Mouhamadou Dia
Cc : pgsql-bugs@postgresql.org
Objet : Re: RE : [BUGS] BUG #3519: Postgres takes the wrong query plan resulting in performance issues

Mouhamadou Dia wrote:
> I'm sending in attachment the output of the explain analyze command and the create table statements of tables
involvedin the query. 

Wait, you said that the query takes 20 seconds on 8.2, but the explain
analyze output says that it actually took 50 seconds. Is this the output
from 8.2.4?

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com
Вложения

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

Предыдущее
От: "Mouhamadou Dia"
Дата:
Сообщение: RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues
Следующее
От: "Peter Koczan"
Дата:
Сообщение: Re: BUG #3504: Some listening sessions never return from writing, problems ensue