varchar(32) NOT NULL,
begin_date date NOT NULL,
eff_date_end date NULL,
code varchar(100) NULL,
CONSTRAINT test1_pkey PRIMARY KEY (vpd_key, id, begin_date)
);
Thank you.
Regards,
Ramesh G
From: Tom Lane
Sent: Wednesday, September 16, 2020 10:17
"Gopisetty, Ramesh" writes:
> Policy
> create policy policy_sel on test FOR SELECT to ram1 USING ( testkey in
> (f_sel_policy_test(testkey)) );
> Going to a Sequential scan instead of index scan. Hence, performance issue.
> If i replace the policy with stright forward without function then
De: "Gopisetty, Ramesh"
Para: "pgsql-performance"
Enviadas: Quarta-feira, 16 de setembro de 2020 0:39:08
Assunto: Performance issue when we use policies for Row Level Security along
with functions
BQ_BEGIN
Hi,
I'm seeing a strange behavior when we implement policies (for RLS - Row
