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

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: BUG #3519: Postgres takes the wrong query plan resulting in performance issues
Дата
Msg-id 46B76928.4050008@enterprisedb.com
обсуждение исходный текст
Ответ на BUG #3519: Postgres takes the wrong query plan resulting in performance issues  ("Mouhamadou DIA" <mdia@accovia.com>)
Ответы RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues
Список pgsql-bugs
Дерево обсуждения 
Mouhamadou DIA wrote:
> I've migrated to Postgres 8.2.4 and run the same query. It takes now 20
> seconds which is still not acceptable.

To help you with that, we'd need to see the EXPLAIN ANALYZE output of
the query, and the CREATE TABLE statements of the tables involved in the
query and their indexes.

Have you vacuumed and ANALYZEd your database recently?

PS. This is not a bug. Please don't use the bug reporting form for
classic performance issues.

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

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #3518: ERROR: IN types character varying and integer cannot be matched
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues