Re: Faster "SET search_path"

Jeff Davis <pgsql@j-davis.com>

View thread View on postgr.es

From: Jeff Davis <pgsql@j-davis.com>

To: Nathan Bossart <nathandbossart@gmail.com>

Cc: Isaac Morland <isaac.morland@gmail.com>, pgsql-hackers@postgresql.org

Date: 2023-09-12T20:55:22Z

Lists: pgsql-hackers

Attachments

v5-0003-Add-cache-for-recomputeNamespacePath.patch (text/x-patch) patch v5-0003

On Mon, 2023-08-07 at 15:39 -0700, Nathan Bossart wrote:
> 0003 is looking pretty good, too, but I think we
> should get some more eyes on it, given the complexity.

Attached rebased version of 0003.

-- 
Jeff Davis
PostgreSQL Contributor Team - AWS

Commits

Fix missing invalidations for search_path cache.
- b3bd18294ee4 18.0 landed
- d3e076549b99 17.0 landed
Optimize SearchPathCache by saving the last entry.
- a86c61c9eefa 17.0 landed
Optimize check_search_path() by using SearchPathCache.
- ad57c2a7c586 17.0 landed
Be more paranoid about OOM in search_path cache.
- 8efa301532c8 17.0 landed
Add cache for recomputeNamespacePath().
- f26c2368dcae 17.0 landed
Transform proconfig for faster execution.
- 5765cfe18c59 17.0 landed