No information about the internal implementation for RLS

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: kes-kes(at)yandex(dot)ru
Subject: No information about the internal implementation for RLS
Date: 2025-06-29 21:04:14
Message-ID: 175123105452.1773110.10116300204980532671@wrigleys.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/17/ddl-rowsecurity.html
Description:

https://www.postgresql.org/docs/current/ddl-rowsecurity.html
The document does not contain any information how RLS are applied to the
main WHERE and how they are used by optimizer. For example there is no
examples which indexes will be used if for RLS x column was used, in the
main query y column was used and when table has indexes for all: x, y and
combined index (x,y) columns.
It would be really helpful to see this information to understand performance
impact.
Thank you.

Browse pgsql-docs by date

  From Date Subject
Next Message Nisha Moond 2025-06-30 11:32:07 Re: Mention idle_replication_slot_timeout in pg_replication_slots docs
Previous Message Fujii Masao 2025-06-27 12:10:13 Re: Mention idle_replication_slot_timeout in pg_replication_slots docs