Postgres Pro
Downloads
Home   >   mailing lists

Re: policies with security definer option for allowing inline optimization - Mailing list pgsql-hackers

From Noah Misch
Subject Re: policies with security definer option for allowing inline optimization
Date
Msg-id 20210407022304.GA847424@rfd.leadboat.com
Whole thread Raw
In response to Re: policies with security definer option for allowing inline optimization  (Dan Lynch <pyramation@gmail.com>)
List pgsql-hackers
Tree view 
On Tue, Apr 06, 2021 at 01:16:16PM -0700, Dan Lynch wrote:
> Final question: do you think using procedures vs writing inline queries for
> RLS quals/checks has a big difference in performance (assuming functions
> are sql)?

If the function meets the criteria for inlining (see inline_function()),
there's negligible performance difference.  Otherwise, the performance
difference may be large.

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: Allow batched insert during cross-partition updates
Next
From: Japin Li
Date:
Subject: Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax