Postgres Pro
Downloads
Home   >   mailing lists

Re: Faster "SET search_path" - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Faster "SET search_path"
Date
Msg-id CA+TgmoYWMSVmH6DjogQExBVKDMc8ZjT8w63YrVHDXJfn_26AiA@mail.gmail.com
Whole thread Raw
In response to Faster "SET search_path"  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers
Tree view 
On Sat, Jul 29, 2023 at 11:59 AM Jeff Davis <pgsql@j-davis.com> wrote:
> Unfortunately, adding a "SET search_path" clause to functions slows
> them down. The attached patches close the performance gap
> substantially.

I haven't reviewed the code but I like the concept a lot. This is badly needed.

--
Robert Haas
EDB: http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: pgsql: Fix search_path to a safe value during maintenance operations.
Next
From: Peter Geoghegan
Date:
Subject: Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan