Sorry, This output is coming from PG 8.1.19 I'm attaching the one that is coming from 8.2.4 Thanks and sorry for the confusion
-----Message d'origine----- De : Heikki Linnakangas [mailto:[EMAIL PROTECTED] De la part de Heikki Linnakangas Envoyé : 6 août 2007 15:32 À : Mouhamadou Dia Cc : pgsql-bugs@postgresql.org Objet : Re: RE : [BUGS] BUG #3519: Postgres takes the wrong query plan resulting in performance issues 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
export_8.2.4.csv
Description: export_8.2.4.csv
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
