pgsql: Optimize check_search_path() by using SearchPathCache.

From: Jeff Davis <jdavis(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Optimize check_search_path() by using SearchPathCache.
Date: 2023-11-21 00:13:54
Message-ID: E1r5EOn-006R2v-Qo@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2023-11-21 01:53:02 pgsql: docs: meson: Change what 'docs' target builds
Previous Message Jeff Davis 2023-11-20 23:38:09 pgsql: Be more paranoid about OOM in search_path cache.