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

2023-10-26 Thread Alexander Okulovich
Hi Tom, I've attempted to reproduce this on my PC in Docker from the stage database dump, but no luck. The first query execution on Postgres 15 behaves like on the real stage, but subsequent ones use the index. Also, they execute much faster. Looks like the hardware and(or) the data structure

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

2023-10-26 Thread Tom Lane
Alexander Okulovich writes: > I've attempted to reproduce this on my PC in Docker from the stage > database dump, but no luck. The first query execution on Postgres 15 > behaves like on the real stage, but subsequent ones use the index. Can you force it in either direction with "set enable_seqs