Row-Level Security (RLS) causes severe query performance degradation
7When Row-Level Security is enabled in production, query execution plans degrade dramatically. Fast SELECT queries become slow with unexpected multi-table joins, and indexes become ineffective, turning a simple database operation into a performance nightmare.
performancePostgreSQLRow-Level Security