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.
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 |