Performance issue when we use policies for Row Level Security along with functions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sunday, October 11, 2020, Gopisetty, Ramesh <rameshg2@xxxxxxxxxxxx> 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.

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux