RLS + XPATH
Team,
While on the road in Iowa visiting covered bridges I met up with an amazing
individual named Brent. Brent, is with a small organization named: Darpa.
They are using PostgreSQL + RLS + XPATH but unfortunately the performance
has been less than what those who use PostgreSQL on a daily basis would
expect. Specifically when using RLS + XPATH, the optimizer does not
prefilter and will scan every row. This has taken their previous queries on
another database from sub second, to 25+ seconds on PostgreSQL.
Unfortunately, we were at a covered bridge park (see attached) and weren't
able to get deeper into the issue. That said, I did tell him that I would
report the issue. Maybe there is traction, maybe there isn't to get this
issue fixed.
May the code be with you,
JD
--
- Founder - https://commandprompt.com/ - 24x7x365 Postgres since 1997
- Founder and Co-Chair - https://postgresconf.org/
- Founder - https://postgresql.us - United States PostgreSQL
- Public speaker, published author, postgresql expert, and people
believer.
- Host - More than a refresh
<https://commandprompt.com/about/more-than-a-refresh/>: A podcast about
data and the people who wrangle it.
Attachments:
bridge.jpgimage/jpeg; name=bridge.jpgDownload
���� JFIF H H �� �Exif II*
� � � � ( 1
� 2 � i� � � samsung SM-G998U H H GIMP 2.10.30 2022:10:31 10:36:33 �� �� "� '� � 0220� � , � @ � H �
P � X �
` �
h � p � �
� x � � � � � � � � � � � � � % � d 2022:10:29 15:54:41 2022:10:29 15:54:41 -05:00 -05:00 � d � d l d d � d � d d d XA8XLNF00SM � � � ���� JFIF �� C
$.' ",#(7),01444'9=82<.342�� C
2!!22222222222222222222222222222222222222222222222222�� � "