Thread: 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,
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: A podcast about data and the people who wrangle it.
Attachment
On 10/31/22 13:37, Joshua Drake wrote: > 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. The related functions need to be marked leakproof to get decent performance from RLS. -- Joe Conway PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com