Horton

Optimize check_search_path() by using SearchPathCache.

Jeff Davis <jdavis@postgresql.org>

View on postgr.es
Commit: ad57c2a7c58665c14236a999435d37ba59eb7fc4
Author: Jeff Davis <jdavis@postgresql.org>
Date: 2023-11-20T23:53:42Z
Releases: 17.0 
Optimize check_search_path() by using SearchPathCache.

A hash lookup is faster than re-validating the string, particularly
because we use SplitIdentifierString() for validation.

Important when search_path changes frequently.

Discussion: https://postgr.es/m/04c8592dbd694e4114a3ed87139a7a04e4363030.camel%40j-davis.com

Files

PathChange+/−
src/backend/catalog/namespace.c modified +54 −2

Discussion