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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
