Thread: pgsql: Improve possible performance regression

pgsql: Improve possible performance regression

From
Peter Eisentraut
Date:
Improve possible performance regression

Commit ce62f2f2a0a introduced calls to GetIndexAmRoutineByAmId() in
lsyscache.c functions.  This call is a bit more expensive than a
simple syscache lookup.  So rearrange the nesting so that we call that
one last and do the cheaper checks first.

Reported-by: Tom Lane <tgl@sss.pgh.pa.us>
Discussion: https://www.postgresql.org/message-id/flat/E1tngY6-0000UL-2n%40gemulon.postgresql.org

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/7f24c0274385ea3d4c797cc2fd60d9a55f3a8d74

Modified Files
--------------
src/backend/utils/cache/lsyscache.c | 22 ++++++++++++++++------
1 file changed, 16 insertions(+), 6 deletions(-)