I'm sending in attachment the output of the explain analyze command and the create table statements of tables involved in the 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:[EMAIL PROTECTED] 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
export.csv
Description: export.csv
list tables.sql
Description: list tables.sql
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
