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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly