Forum OpenACS Q&A: Re: Problem with acs-subsite query "permissions" (need help)

What does EXPLAIN give you for the subquery in 2.0? This is quite the mystery since you've verified that the queries and db engine are exactly the same.

Have you run VACUUM FULL ANALYZE since updating? (I'm sure the answer's yes from the plans you've posted, I'm grasping at straws here).

How does one cause EXPLAIN to expand subquery plans rather than simply say "Subquery Scan (*SELECT* 5)"?