Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> writes:
> SELECT DISTINCT main.* FROM
> (
> (
> (
> (
> Tickets main JOIN Groups as Groups_1 ON ( main.id = Groups_1.Instance)
> ) JOIN
> Principals as Principals_2 ON ( Groups_1.id = Principals_2.ObjectId)
> ) JOIN
> CachedGroupMembers as CachedGroupMembers_3 ON ( Principals_2.id = CachedGroupMembers_3.GroupId)
> ) JOIN
> Users as Users_4 ON ( CachedGroupMembers_3.MemberId = Users_4.id)
> ) WHERE
> ...
I think the reason for the performance difference is that 7.3 treats
JOIN syntax as forcing a particular join order, while 7.4 doesn't.
regards, tom lane