Performance issue when we use policies for Row Level Security along with functions - Mailing list pgsql-performance

From David G. Johnston
Subject Performance issue when we use policies for Row Level Security along with functions
Date
Msg-id CAKFQuwYou+Zrs1iN+2ByTrM92t4WgN5ETFKjuvRMqerWncdy9w@mail.gmail.com
Whole thread Raw
In response to Re: Performance issue when we use policies for Row Level Security along with functions  ("Gopisetty, Ramesh" <rameshg2@illinois.edu>)
List pgsql-performance
On Sunday, October 11, 2020, Gopisetty, Ramesh <rameshg2@illinois.edu> wrote:

    to sch USING  ( key = 
        f_sel_1(key)
    );

As Tom said it doesn’t matter what you classify the function as (stable, etc) if your function call accepts a column reference as an input and compares its output to another column reference.  With a column reference you need a row to find a value and if you already have a row the index serves no purpose.

David J.

pgsql-performance by date:

Previous
From: "Gopisetty, Ramesh"
Date:
Subject: Re: Performance issue when we use policies for Row Level Security along with functions
Next
From: Parth Shah
Date:
Subject: Slow Query