"David R. Pike" <david.p...@trustedconcepts.com> writes: > I recently applied RLS to several large (several million rows) tables in my > 9.5 database and noticed that queries against a single large RLS protected > table perform well however queries that join several large RLS protected > tables perform very poorly. The explain plan shows the optimizer is scanning > the entire table to enforce the RLS policy before executing the primary key > join that would reduce the query results to a single row from each table. > Clearly performance would be better if it performed the join before the > policy check.
Join cases with RLS aren't optimized very well at the moment. There's work afoot to improve this - see https://www.postgresql.org/message-id/flat/8185.1477432701%40sss.pgh.pa.us - but it won't be in production before v10. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
