Performance / Article
Row-level security performance in PostgreSQL, measured
The article measures how RLS policy formulation changes query plans and latency on PostgreSQL 17.10, comparing setting-based predicates, helper-function volatility, membership subqueries and non-leakproof expressions. It reports that volatile PL/pgSQL helpers, IN (SELECT ...) membership checks and non-leakproof functions such as lower() can each prevent index use.
Read the originalWhy it’s in the collection
Helps SaaS teams and DBAs write RLS policies and indexes that keep tenant queries fast instead of silently degrading.
THE CONVERSATION
Found on Hacker News 1
Links lead to the original story or comment where this resource appeared. Titles identify the surrounding discussion.