pgsql: Optimize check_search_path() by using SearchPathCache. - Mailing list pgsql-committers

From Jeff Davis
Subject pgsql: Optimize check_search_path() by using SearchPathCache.
Date
Msg-id E1r5EOn-006R2v-Qo@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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(-)


pgsql-committers by date:

Previous
From: Jeff Davis
Date:
Subject: pgsql: Be more paranoid about OOM in search_path cache.
Next
From: Andres Freund
Date:
Subject: pgsql: meson: Document build targets, add 'help' target