I'm sending in attachment the output of the explain analyze command and the create table statements of tables involved
inthe query.
Yes, I have vacuumed and analyzed my database this morning before running the query.
I'm sorry; I thought it was a bug with the optimizer, that's why I used the reporting bug
Thanks for your help
-----Message d'origine-----
De : Heikki Linnakangas [mailto:hlinnaka@gmail.com] De la part de Heikki Linnakangas
Envoyé : 6 août 2007 14:32
À : Mouhamadou Dia
Cc : pgsql-bugs@postgresql.org
Objet : Re: [BUGS] BUG #3519: Postgres takes the wrong query plan resulting in performance issues
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