Postgres 15 SELECT query doesn't use index under RLS

2023-10-13 Thread Alexander Okulovich
Hello everyone! Recently, we upgraded the AWS RDS instance from Postgres 12.14 to 15.4 and noticed extremely high disk consumption on the following query execution: select (exists (select 1 as "one" from "public"."indexed_commit" where "public"."indexed_commit"."repo_id" in (964992,964994,9

Re: Postgres 15 SELECT query doesn't use index under RLS

2023-10-13 Thread Tom Lane
Alexander Okulovich writes: > Recently, we upgraded the AWS RDS instance from Postgres 12.14 to 15.4 > and noticed extremely high disk consumption on the following query > execution: > select (exists (select 1 as "one" from "public"."indexed_commit" where > "public"."indexed_commit"."repo_id" i