From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | Joshua Drake <jd(at)commandprompt(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: RLS + XPATH |
Date: | 2022-10-31 21:55:03 |
Message-ID: | 115cc7ce-49fe-de0c-6ee3-2f6383604230@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ilya Gladyshev | 2022-10-31 22:02:42 | Re: Segfault on logical replication to partitioned table with foreign children |
Previous Message | Ilya Gladyshev | 2022-10-31 21:52:19 | Re: Segfault on logical replication to partitioned table with foreign children |