Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION }
Robert Haas <robertmhaas@gmail.com>
From: Robert Haas <robertmhaas@gmail.com>
To: Jeff Davis <pgsql@j-davis.com>
Cc: Peter Eisentraut <peter@eisentraut.org>, pgsql-hackers@postgresql.org
Date: 2023-11-20T20:52:41Z
Lists: pgsql-hackers
On Tue, Nov 14, 2023 at 11:21 PM Jeff Davis <pgsql@j-davis.com> wrote: > After adding the search path cache (recent commit f26c2368dc) hopefully > that helps to make the above suggestion more reasonable performance- > wise. I think we can call that progress. I agree. Not to burden you, but do you know what the overhead is now, and do you have any plans to further reduce it? I don't believe that's the only thing we ought to be doing here, necessarily, but it is one thing that we definitely should be doing and probably the least controversial. -- Robert Haas EDB: http://www.enterprisedb.com
Commits
-
Cache opaque handle for GUC option to avoid repeasted lookups.
- 867dd2dc8704 17.0 landed
-
Add cache for recomputeNamespacePath().
- f26c2368dcae 17.0 cited