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

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Mouhamadou Dia <MDia(at)accovia(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues
Date: 2007-08-06 19:31:58
Message-ID: 46B7772E.8090807@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Mouhamadou Dia wrote:
> I'm sending in attachment the output of the explain analyze command and the create table statements of tables involved in 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Mouhamadou Dia 2007-08-06 19:44:59 RE : RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues
Previous Message Mouhamadou Dia 2007-08-06 18:57:52 RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues