"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
> Is the price of looking up a schema a deal breaker here, or is it
> possible to avoid it?
My guess is "no" as to both questions. I've never seen any profiles
suggesting that permissions-checking is a significant part of query
startup. In any case, if you assume that the same set of permissions
are going to get checked either way (they're just distributed
differently) then the only direct cost involved would be one additional
syscache fetch, which surely ought not be significant.
regards, tom lane