Re: [GENERAL] Row level security performance joining large tables

David, * David R. Pike (david.p...@trustedconcepts.com) wrote: > From what I can understand the RLS implementation strives to execute policy > checks before user provided predicate checks so as to avoid leaking protected > data. Is there any way to make the join look "safe" to the optimizer to

Re: [GENERAL] Row level security performance joining large tables

"David R. Pike" 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

[GENERAL] Row level security performance joining large tables

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