Postgres Pro
Downloads
Home   >   mailing lists

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

From Heikki Linnakangas
Subject Re: BUG #3519: Postgres takes the wrong query plan resulting in performance issues
Date
Msg-id 46B76928.4050008@enterprisedb.com
Whole thread Raw
In response to BUG #3519: Postgres takes the wrong query plan resulting in performance issues  ("Mouhamadou DIA" <mdia@accovia.com>)
Responses RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #3518: ERROR: IN types character varying and integer cannot be matched
Next
From: Heikki Linnakangas
Date:
Subject: Re: RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues