Postgres Pro
Downloads
Home   >   mailing lists

Re: RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues - Mailing list pgsql-bugs

From Heikki Linnakangas
Subject Re: RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues
Date
Msg-id 46B7772E.8090807@enterprisedb.com
Whole thread Raw
Responses RE : RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues
List pgsql-bugs
Tree view 
Mouhamadou Dia wrote:
> I'm sending in attachment the output of the explain analyze command and the create table statements of tables
involvedin 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

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #3519: Postgres takes the wrong query plan resulting in performance issues
Next
From: Heikki Linnakangas
Date:
Subject: Re: RE : RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues