Skip site navigation (1) Skip section navigation (2)

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

From: "Mouhamadou Dia" <MDia(at)accovia(dot)com>
To: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues
Date: 2007-08-06 18:57:52
Message-ID: BB6605E56C79CB4FA6CA491B706FBB210112DC@cpt127.magrit.int (view raw or flat)
Thread:
Lists: pgsql-bugs
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:hlinnaka(at)gmail(dot)com] De la part de Heikki Linnakangas
Envoyé : 6 août 2007 14:32
À : Mouhamadou Dia
Cc : pgsql-bugs(at)postgresql(dot)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

Attachment: list tables.sql
Description: application/octet-stream (20.0 KB)
Attachment: export.csv
Description: application/octet-stream (4.6 KB)

In response to

Responses

pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2007-08-06 19:31:58
Subject: Re: RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues
Previous:From: Heikki LinnakangasDate: 2007-08-06 18:32:08
Subject: Re: BUG #3519: Postgres takes the wrong query plan resulting in performance issues

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group