pgsql: Optimize SearchPathCache by saving the last entry.

From: Jeff Davis <jdavis(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Optimize SearchPathCache by saving the last entry.
Date: 2023-12-05 01:30:31
Message-ID: E1rAKGc-008dS7-RV@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Optimize SearchPathCache by saving the last entry.

Repeated lookups are common, so it's worth it to check the last entry
before doing another hash lookup.

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

Branch
------
master

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

Modified Files
--------------
src/backend/catalog/namespace.c | 88 ++++++++++++++++++++++++++---------------
1 file changed, 57 insertions(+), 31 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Amit Kapila 2023-12-05 03:51:50 pgsql: Fix a random failure in 003_logical_slots.pl.
Previous Message Nathan Bossart 2023-12-04 17:56:24 pgsql: Teach convert() and friends to avoid copying when possible.