I don't have a performance answer on what gets "cached" in RLS joins/selects. Using a postgres stable function is one thing I use when I know the data is the same for each row being check with the policy. https://www.postgresql.org/docs/current/xfunc-volatility.html