Performance Issue (Not using Index when joining two tables).

2020-09-13 Thread Gopisetty, Ramesh
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

Re: Performance Issue (Not using Index when joining two tables).

2020-09-14 Thread Gopisetty, Ramesh
_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

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

2020-09-16 Thread Gopisetty, Ramesh
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))

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

2020-10-12 Thread Gopisetty, Ramesh
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