Update extension lookup routines to use the syscache The following routines are changed to use the syscache entries added for pg_extension in 490f869d92e5: - get_extension_oid() - get_extension_name() - get_extension_schema()
A catalog scan is costly and could easily lead to a noticeable performance impact when called once or more per query, so this is going to be helpful for developers for extension data lookups. Author: Andrei Lepikhov Reviewed-by: Jelte Fennema-Nio Discussion: https://postgr.es/m/[email protected] Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/d8df7ac5c04cd17bf13bd3123dcfcaf8007c6280 Modified Files -------------- src/backend/commands/extension.c | 82 +++++++--------------------------------- 1 file changed, 13 insertions(+), 69 deletions(-)
