Thread: pgsql: Optimize check_search_path() by using SearchPathCache.

pgsql: Optimize check_search_path() by using SearchPathCache.

From
Jeff Davis
Date:
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

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/ad57c2a7c58665c14236a999435d37ba59eb7fc4

Modified Files
--------------
src/backend/catalog/namespace.c | 56 +++++++++++++++++++++++++++++++++++++++--
1 file changed, 54 insertions(+), 2 deletions(-)