> > it helped, the new version of the query takes 2303 ms on both 8.1.4 
> > and 8.2.4.
> 
> And the old one?

slightly shorter, 2204 ms.

as a subjective perception, the entire application is slightly slower on 8.2.4, 
probably there are many queries that were manually tunned for 7.x/8.1.x and now 
need rewriting, which is not really what I expected from an upgrade.
 

Liviu


---------------------------(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

Reply via email to