Hi,
Good Morning!
Postgres Version : 11.6 (AWS Native Postgres/AWS Aurora tried on both
flavours).
When i'm joining two tables the primary index is not being used. While is use
in clause with values then the index is being used. I have reindexed all the
tables, run the auto vaccum as w
_position;
count
---
3923
(1 row)
pgwfc01q=> select count(*) from wfnsch001.chr_Simple_Val;
count
---
88929
(1 row)
I'm not sure if i'm thinking in the right way or not. (As of safety purpose, i
have rebuilded indexes, analyzed, did vaccum on those tables). Sorry for
Hi,
I'm seeing a strange behavior when we implement policies (for RLS - Row level
security) using functions.
table test consists of columns testkey,oid,category,type,description...
Policy
create policy policy_sel on test FOR SELECT to ram1 USING ( testkey in
(f_sel_policy_test(testkey))
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