The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/17/ddl-rowsecurity.html
Description:
https://www.postgresql.org/docs/current/ddl-rowsecurity.html
The document does not contain any information how RLS are applied to the
main WHERE and how they are used by optimizer. For example there is no
examples which indexes will be used if for RLS x column was used, in the
main query y column was used and when table has indexes for all: x, y and
combined index (x,y) columns.
It would be really helpful to see this information to understand performance
impact.
Thank you.