Re: Create syscaches for pg_extension - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Re: Create syscaches for pg_extension
Date
Msg-id CAPpHfdsQnXcKZT2D7Evv-uuugcbToOri5fnoNcMiqLq9UtyWXQ@mail.gmail.com
Whole thread Raw
In response to Re: Create syscaches for pg_extension  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
On Tue, Aug 13, 2024 at 5:23 PM Pavel Stehule <pavel.stehule@gmail.com> wrote:
> út 13. 8. 2024 v 16:13 odesílatel Jelte Fennema-Nio <postgres@jeltef.nl> napsal:
>>
>> Shared libraries of extensions might want to invalidate or update their
>> own caches whenever a CREATE/ALTER/DROP EXTENSION command is run for
>> their extension (in any backend). Right now this is non-trivial to do
>> correctly and efficiently. But if the extension catalog was part of a
>> syscache this could simply be done by registering an callback using
>> CacheRegisterSyscacheCallback for the relevant syscache.
>>
>> This change is only made to make the lives of extension authors easier.
>> The performance impact of this change should be negligible, since
>> updates to pg_extension are very rare.
>
>
> +1

+1 from me too

------
Regards,
Alexander Korotkov
Supabase



pgsql-hackers by date:

Previous
From: Sofia Kopikova
Date:
Subject: Apply PGDLLIMPORT markings to some GUC variables
Next
From: Greg Sabino Mullane
Date:
Subject: Re: Enable data checksums by default