Re: [PERFORM] Row level security policy policy versus SQL constraints. Any performance difference?

2017-10-17 Thread Joe Carlson
olicy every time. Thanks, Joe On 10/17/2017 03:06 PM, Tom Lane wrote: Tomas Vondra writes: On 10/17/2017 10:44 PM, Joe Carlson wrote: What I was wondering is what is the performance differences between a row level security implementation: ... and an implementation where I add on the constr

[PERFORM] Row level security policy policy versus SQL constraints. Any performance difference?

2017-10-17 Thread Joe Carlson
Hello. I have not used row level security policies in the past but am considering using them for a project in which I would like to restrict the set returned in a query based on specific fields. This is more as a convenience issue (for me) rather than a security issue. What I was wondering i