v.22.8Improvement
Support for Primary Key Analysis and Issue Fixes in Row Policies
Support primary key analysis forrow_policy_filterandadditional_filter. It also helps fix issues like #37454 . #39826 (Amos Bird).
Why it matters
This feature enhances query optimization by enabling primary key analysis to be applied torow_policy_filter and additional_filter. It fixes issues related to incorrect or inefficient filtering caused by the lack of primary key insight in these filters, such as the problem described in issue #37454.How to use it
The feature is applied automatically when usingrow_policy_filter and additional_filter in your queries or table configurations. There is no additional user action needed beyond defining row-level security policies or additional filters as usual.