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

What query plan do you get for the deleted subquery?

We saw a case on where PG 7.4 fell on its face on a query involving a view where in 7.3 it was very fast. Apparently 7.4 decided to materialize the view.