Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Davis
Subject Re: Faster "SET search_path"
Date
Msg-id 695668acc40b937258985669f3d55b94cce82c3c.camel@j-davis.com
Whole thread Raw
In response to Re: Faster "SET search_path"  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: Faster "SET search_path"
Re: Faster "SET search_path"
List pgsql-hackers
Tree view 
On Thu, 2023-10-19 at 19:01 -0700, Jeff Davis wrote:
> 0003: Cache for recomputeNamespacePath.

Committed with some further simplification around the OOM handling.
Instead of using MCXT_ALLOC_NO_OOM, it just temporarily sets the cache
invalid while copying the string, and sets it valid again before
returning. That way, if an OOM occurs during the string copy, the cache
will be reset.

Also some minor cleanup.

> 0004: Use the same cache to optimize check_search_path().
> 0005: Optimize cache for repeated lookups of the same value.

I intend to commit these fairly soon, as well.

Regards,
    Jeff Davis

pgsql-hackers by date:

Previous
From: Amul Sul
Date:
Subject: Re: retire MemoryContextResetAndDeleteChildren backwards compatibility macro
Next
From: Amit Kapila
Date:
Subject: Re: add log messages when replication slots become active and inactive (was Re: Is it worth adding ReplicationSlot active_pid to ReplicationSlotPersistentData?)